Search code examples
reporting-servicesssrs-2008ssrs-2008-r2ssrs-tablix

No row message for more than one tablix in SSRS

I created four tablixes for my report. if at least one tablix has no data, I would like to show 'no row message' and no data for other tablixes. Any suggestions are appreciated.

Solution

  • I wrote No row message for only one tablix, and i wrote the following condition for visibility for all tablixes . 

    =IIF((countrows("Dataset1") = 0
AND countrows("Dataset2") = 0
AND countrows("Dataset3") = 0
AND countrows("Dataset4") = 0)
,TRUE,FALSE)