Paginated Report shows but if there is no data it is empty how to force to show when no data

[ResearchDev]

This is what the Design looks like. It works fine when there is data. Basically it is a table and then add a list to the top one where Report Ending Date and up to Station/ Position are just text boxes but binded to the same DataSource. The DWR date is the same table used. I tried to use the Row Visibility on the tablix (see all the way below) and code to show or hide the row using this: IIf(CountRows("DataSetName") > 0, True, False). But somehow it is still not showing.

When there is no data, nothing shows

When there is data this is shown

[v-xiaotang · Accepted solution]

Hi @ResearchDev 

Thanks for reaching out to us.

>> When there is no data, nothing shows

One idea, if there is no data, output=" " (text with spaces, instead of null)

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.