Paginated Report - NoRowsMessage not working on sub report

[JimJim]

Hi Guys,

I have 2 reports, a sub report and a parent report.

On the sub report, I have a text box with some instructions for end users and a tablix. I have set the tablix property 'NoRowsMessage' so that when no data is returned, a message will be displayed. When I run the sub report on the report server, this works just fine.

When I run the parent report and when the sub report returns no rows, I only get a blank page. I can't even see the text box with instructions. It's just completely blank.

Any ideas?

[Greg_Deckler]

@JimJim - Font color the same as the background? That sounds odd.

[JimJim]

Hi @Greg_Deckler , Thanks for replying.

When I run the sub-report on its own, the NoRowsMessage displays just fine, it only doesn't display when I run the master report. So I know it's not an issue with font colour.

I have another issue with the sub-report that may be related. On the sub-report I have set the InitialPageName property, this means that when a user exports the report to excel, the excel tab will display the report name. This works when I run the sub-report on its own but when I run the master report and export it to excel, the excel tab is named Sheet1.

[v-lionel-msft]

Hi @JimJim ,

Please refer to the official tutorial.

Set a No Data Message for a Data Region (Report Builder and SSRS) 

Best regards,
Lionel Chen

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

[JimJim · Accepted solution]

Thank you @v-lionel-msft , indeed, NoRowsMessage does not work if you add the report as a sub-report. Once you add the report as a sub-report, you need to set the NoRowsMessage of the sub-report properties to get it working.

[Anonymous]

i have a similar problem , would be kinda enough to walk me through how to setup a custom message whenever there is no data on the subreport?

[v-lionel-msft]

Hi @JimJim ,

Greate job! Thanks for sharing!

Best regards,
Lionel Chen

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