Hi,
I have a report, where depending on a parameter-value (e.g. Change in day: Yes/No), I need to display the records in one page or multiple pages (i.e. If Change in Day = Yes, display the records for each day in different pages. If No, display all the records in one page). In-short page break for each day, if there is a change in day, else no page break.
Can anyone suggest, is this possible to do with SSRS 2005 RTM ? I had read somewhere that conditional page-breaks is not supported. But, is there any other way I can do this ?
Thanks in Advance.
Isnt there a way to achieve this ?
Its URGENT. Any help is highly appreciated.
|||you need to create a dummy group with "page break at end" true for this and the expression for group will be set according to parameter value
like if user has selected "Yes" then set group expression
=iif(parametrvalue=yes,<fieldname-day>,1)
try this, it should work.
|||Thanks a lot. It worked.
Thanks again.
|||but be careful it will work only if you have only one group in report. If you add more then it won't work.|||How to implement Page break if we are having more than one group
No comments:
Post a Comment