I have a SQL report setup to use grouping. I have page headers/footer that appear on each page. All works well unless there is not data returned from the Data source.
When this happens a single page is displayed that is blank.
I want to place a message on the page saying there is no data available at this time. On this blank page when the data source is empty, it doesn't even render the page header/footer, so I cant put a field with a message that switches visible to true when there are no rows (as I have done elsewhere).
I have added a Report Header, which works when there is no data, but has a blank page when there is data. I do not want a report cover page, and the client does not want and summary info first, they want the data straight away. I have attempted to set the visible Expression to hide the report header when there is no data, but is doesn't seem to work as expected. If I set the report header visible property to false, the page still appears, but doesn't render its contents. This doesn't seem right, if I set a section visible to false it should not appear!
I have tried using report footer, but then the message is only available on the second page, as the report renders the blank page.
I have attached an image showing the hierarchy of the report.
If you require any further information, please don't hesitate to contact me.
Thanks,
Jon
I have managed to fix this, by manually adding a section into the XML, I have added a Section between the PageHeaderSection and the SectionGroupIterator. I have set this section to be hidden when there is data, and placed a message onto it. All works well.
Its a shame the Visual Designer doesn't allow you to add a new section (or I can't find the option to add a section).
Hello Jon and thank you for posting to the community!
I am glad that you have resolved the issue on your side and I believe that the information you have provided will be useful for other users as well. Please feel free to contact us if you have any other questions or concerns.