July 22, 2014 at 4:33 pm
WhilePrintingRecords;
PageNumber > 1
The above one is the code in the crystal, which is used to suppress the details in the crystal report. Can I know what is the equivalent for SSRS. I mean how to suppress using the code similar to crystal in ssrs.
Help is appreciated.
July 30, 2014 at 7:28 pm
I don't think there is an exact equivalent in SSRS. The only regions of the report that "know" the current page number are the header and the footer. You cannot reference the page values in the body of the report. Thus they are the only places you can show or hide report elements based on the page number. The "details" section of any tablix would always be in the body, and thus its visibility cannot be controlled by the page number.
I'm sure you will sympathize when I say that this is a painful lack of functionality in SSRS. I have struggled over how to create section breaks in a directory where each section should begin on an odd-numbered page and thus be on the front of a book-bound set of pages. In another case I needed data-driven values to appear only on the final page of a grouping. And there are other situations in which being able to write expressions in the body of the report with the page number fields would be valuable if not essential functionality. While I'm at it, I should also mention that it would be immensely helpful to know which column is the "current column" for expression purposes also.
But the body of the report has no access to the current page number or column number via expressions. Alas and alack.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply