June 27, 2014 at 1:37 pm
In a new SSRS 2008 report that I just setup, there are 5 datasets that are located on the main report that refer uniquely to 5 tablixes. There are no subreports for performance reasons. The purpose of the ssrs report is to export data to excel and have each report go to a separate tab in the excel workbook. This occus since on each tablix, has the 'add a page break after', 'repeat header columns on each page', and 'keep header visible while scrolling'.
These reports do export to different tabs in excel when they contain data.
On each of the tablixes I have the 'NoRowsMessage' filled in in case there is no data.
The problem occurs when there is no data for a tab (unique report). The message I want for no rows does show up, but the message does not create a new tab in excel. The message appears on top of one of the reports that does have data.
Thus when there is 'no data' for report(s), is there a way in ssrs 2008 to have that message appear on unique tabs in excel when the data is exported to excel? If this is possible, can you tell me how to accomplish this goal?
March 27, 2015 at 8:51 am
I have the same problem - no so no Page Break after.
I solver the page break problem by turning OFF the Page Break After on the tablix and instead add a rectangle with page break after set to true.
But... there is another problem with this.
When exporting to Excel each Excel tab is named after PageName of the tablix.
If no data in the tablix, Excel uses the PageName from the previous tablix as the name (with (2) appended to the name).
I think the only way to deal with this is to have the query return an empty row when there is no data.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply