I am using two data regions to display two types of data... Ones with missing serial numbers, and one with mismatched transportation statuses. When I export my report to excel I seperate each of these types of data onto different sheets using a page break. Then I am able to differentiate which region shows which data by setting a filter based upon an indicator column within my stored procedure. I have one particular report parameter in my SP named @mode and there are three types including missing serial, Badstatus, and ALL (includes both).
The All mode works fine, both regions are on seperate sheets and there is no problem. However, when I run the first two modes which are missingserial/Badstatus. The correct data is displayed for the mode, but it still generates two sheets within the excel file and retains a place holder for the region not in use which ultimately outputs a blank page..
I apologize if I am unclear on anything but I am new to SSRS and Report managing. I appreciate any feedback and thank you ahead of time.
I also forgot to mention, I have tried the following in attempt to fix this:
-Tyler
Try this... In the properties for the last Tablix on the report (which is expected to be the last worksheet upon exporting to excel) - set the Page Break > Break Location = None.
I think what this does is removes the expectation of another "region" after this Tablix in the export process. I also tried this with a footer, it works fine with the footer too after making that little adjustment.
Let us know how it worked out for you. Good luck!