June 16, 2010 at 8:58 pm
I have a report which groups the data based on country. For example, the columns are country name, product name and sales. I grouped the data in tablix based on country. Now, the requirement is the report should show a separate table for each group, with column header. Any SSRS gurus, please help.
September 16, 2010 at 6:09 am
Hi,
Have you tried to add a list control then group that on country, then add a tablix inside the list box?
Regards
September 16, 2010 at 6:33 am
pjrpjr7 (6/16/2010)
I have a report which groups the data based on country. For example, the columns are country name, product name and sales. I grouped the data in tablix based on country. Now, the requirement is the report should show a separate table for each group, with column header. Any SSRS gurus, please help.
I don't get it...
Why do you want 3 seperate data regions?
Raunak J
September 16, 2010 at 7:19 am
If your only issue is the repeating header for each group. Keep a single tablix, and just insert a new row into your group header and put your column headers in that row.
September 17, 2010 at 9:01 am
I think dbowlin has a good solution. If the consumer is picky about appearances, you can add an empty group footer with no borders. The tablix will render like separate tables even though it's really just one table.
September 17, 2010 at 9:20 am
douglane4 (9/17/2010)
I think dbowlin has a good solution. If the consumer is picky about appearances, you can add an empty group footer with no borders. The tablix will render like separate tables even though it's really just one table.
Yes, give them what they want, not what they ask for.
September 17, 2010 at 5:18 pm
Thanks to all.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply