Page break in list control in SSRS 2005
Hi, I am using SSRS 2005. I have a list control which is grouped based on some id. Now I want to have 5 (say n) list items per page. How can I achieve that, I mean how to insert a page break after every n records (list items). Please help.
September 7th, 2009 8:23pm

Hi, Its can be accomplished by group every n records(list items) in one group and enable its page break at end. Please follow these on how to do: 1. Add an identity field for the some id of your dataset. You can use many ways to achieve this depending on your dataset. I assume you use the T-SQL dataset query, so you can add this string into your dataset fields collection: ,dense_rank()over(order by someid) as RowNum (note: if the someid have the identity feature, you can use it directly in the following steps) 2. Add a list control on your report, and place the original list into this new list. 3. For the new list control, set its group expression like this: =(Fields!RowNum.Value-1)\5 and enable its page break at end. (5 = n as you want). Hope this help, Thanks, Jerry
Free Windows Admin Tool Kit Click here and download it now
September 9th, 2009 6:46am

Hi, amit_zen.In fact, you can use RAQ Report. With it, you can set page break for your report easily.The only thing you need to do is setting in the report properties dialog box.
September 9th, 2009 8:20am

Thanks Jerry.
Free Windows Admin Tool Kit Click here and download it now
September 10th, 2009 6:35am

Thanks Jerry
January 7th, 2011 9:36am

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

Other recent topics Other recent topics