SSRS List Page Break
I have 3 lists in the main report and each list contains sub reports. Each list has a different data set. I am able to group each list and add a page break but the problem is when there are not records in the first list then it is leaving a blank page. Is there any way to solve this problem.
January 19th, 2011 7:15am

Hi Varun, Here is something you can try under your list visibility expression:- = IIf( CountRows("ds2") = 0, True, False) "ds2" is my DataSet name. I have attached a sample .rdl file with the below link:- https://docs.google.com/leaf?id=0B9kG9JjPJGAvYmRiOWM0ZmItNzViMy00ZjVkLTk2NWQtMTFlMTUyOTQ4ZTgy&hl=en&authkey=CJ3vpt4E You need to change DataSource accordingly. Please let us know your feedback. Thanks KumarKG, MCTS
Free Windows Admin Tool Kit Click here and download it now
January 20th, 2011 10:18am

Hi Varun, Here is something you can try under your list visibility expression:- = IIf( CountRows("ds2") = 0, True, False) "ds2" is my DataSet name. I have attached a sample .rdl file with the below link:- https://docs.google.com/leaf?id=0B9kG9JjPJGAvYmRiOWM0ZmItNzViMy00ZjVkLTk2NWQtMTFlMTUyOTQ4ZTgy&hl=en&authkey=CJ3vpt4E You need to change DataSource accordingly. Please let us know your feedback. Thanks KumarKG, MCTS
January 20th, 2011 10:18am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics