Display data in SSRS

Question

I have two tables on the SSRS report which displays data depending on the results returned by a single dataset. The second table displays a subset of data which is displayed on the first depending on some parameters.Now I would like to implement a functionality which displays "no rows" in the second table if the countrows=0 (subset returned from first table) and display the data(subset of data in the first table) if the countrows>0

How can I implement this?

Answer 1

There is a property on the table called "NoRows" that allows you to enter any text you want to show if there are no rows returned.