May 27, 2009 at 4:22 am
Hi All,
I have created a report in SSRS 2005 with grouping.
In the report, i have 100 groups, so i want to show 10 groups for each page. so what is the process.
pls suggest me in this regard...
Thanks
Sathish B
May 27, 2009 at 9:09 am
I'm not sure that you can guarantee exactly 10 groups per page because each group will expand/contract based on the # of rows in the group.
Can you give some information on the groups? Are they nested groups or is it 1 group like grouping on customers that has a 100 values?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
May 27, 2009 at 10:36 pm
Thanks Jack,
I am having only one group. so i want to display 10 groups in a page.
when the first group expands, then the page should display the details of the group along with other 9 groups.
suggestions are appreciated...
Thanks
Sathish B
May 28, 2009 at 6:20 am
Not sure if your dataset is fixed or dynamic, but you could
add a row count to your dataset and create 10 tables in the report, then place a filter on the rowcount to display 10 records per table
May 28, 2009 at 7:02 am
Jason has the right idea as there is no way to use an expression to set a page break.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply