I created an rdl that creates a 3 page report. On page 2 there are some 10 tablix with one row each. I have set an expression for the row visibility and Row Group visibility in each tablix to avoid white space when the row is hidden. When I test this report in Visual studio and or report server the report is displayed perfectly, with no white space for hidden rows. The report displayed has 3 pages with any member id.
Now, I created a c# web application that uses ReportService2005.asmx and ReportExecution2005.asmx web services to save this report as pdf. On the user interface I pass in the member id and run the rdl, and save the report on file server. It works fine except that the pdf has more more then 3 pages and has white spaces for the hidden rows/tablix. How do I make the pdf resemble the report exactly as it is displayed on the report server or in visual studio preview ?