Geek Answers Handbook

Data mapping in SSRS

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

How to implement this?

+4
source share
2 answers

The table has a property called "NoRows" that allows you to enter any text that you want to display if there are no returned rows.

enter image description here

+11
source

you can also use this solution: for your dataset2 click the tablix tab, and below you will get the Row groups. Click on each of the row groups. Therefore, if you have 1 child and 1 parent, you will have to do this on both. 1) Right-click group_child-> group properties-> filters and put the following expression "=IsNothing(Fields!Group_Child.Value)="True"" " ; set it as a logical expression and 'value'='False' , and you will need to do the same for Group_parent1 through n. This will display NO rows if you don’t have data for the lower dataset. If this is the same thing you want to do with Tablix 1, go to it.

-1
source

More articles:


All Articles