Is it possible for the first group to be repeated?
For example if I have a group on
Country_group
State_group
City_group
Items
So the outcome of the report is something like this:
USA
Calif
Sacramento
My 1<sup>st</sup>
data goes here for Sacto.
My 2<sup>nd</sup> data goes
here for Sacto.
San Diego
My 1<sup>st</sup> data goes here for San Diego
Oregon
Portland
Data for Portland
It is required for me to do something like this
USA
Calif
Sacramento
My 1<sup>st</sup> data goes
here for Sacto.
My 2<sup>nd</sup> data goes
here for Sacto.
San Diego
My 1<sup>st</sup> data goes here for San Diego
USA
Oregon
Portland
Data for Portland
Is it a way to do this?
Thank you.
November 15th, 2010 9:04pm
Hi,
This can be achived. Please try the below steps
1) Add a tablix and drag the fields for the Item row (that are coming under the cities)
2) In the group pane, right click the detail group and select add parent group and choose the city field to group by, check the add group header, click ok.
3) Now right click the city group, and select add parent group and choose state as the field to group by, check the add group header.
4) Now right click the state group, and select add group and choose the country field group by. for this do not choose the add group header.
5) Right click the state cell in the tablix and choose split cells
6) Right click the row that has the header for state and choose insert row-> above
7) In the cell just above the state column, (in the row inserted in above step), choose the field country
8) Right click the first column (country column) header and select delete column, then choose 'delete column only' before clicking ok.
Hope this helpsPlease click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.
BH
Free Windows Admin Tool Kit Click here and download it now
November 16th, 2010 12:51am
Hi,
If you have the Group headers and group values correctly then in the tablix control properties enable the "Repeat header rows on each page"
Thanks,
Veeren.Thanks & Regards, Veeren Chowdary.
November 16th, 2010 2:02am
Bilal,
thanks for your info and help, each field of mine are sometimes are long and I could not use (didin't know how to use the tablix method "Table"). So I found this link
http://www.bidn.com/blogs/kylewalker/ssis/657/how-to-create-a-single-column-multiple-group-grouping-in-ssrs
and used that method but instead of table I used List and my output and format worked very well just almost at the end of project it was point out to me that they want the "Country" to be repeated. In my situation sometimes the city can be null or
even state.
I will try your method as well and use table to see if I can achive it this way but I already done all my work in "List" format.
Any idea how can I do this in "List" format?
Thank you again.
Free Windows Admin Tool Kit Click here and download it now
November 16th, 2010 10:34am
Hi,
By generally, we can use Table to achieve this.
For example, according to the link you posted, I have built a table as the following pictures shows:
Currently, each country name is not repeated when preview. In order to make country names to be repeated for each state. Please refer to the steps below:
1.
Right click the handle of the
CountryName group header, select Delete Rows.
In the popup Delete Rows dialog, select Delete rows only, then click
OK.
2.
Right click the handle of
StateName group header, select Insert Row -> Inside Group – Above.
3.
Drag the
CountryName field from the Dataset and drop it to the first cell in the new Group Header.
After that, we will get the table like the picture below and country names are repeated for each state when preview the report:
If you have already achieved by using List, please post its structure and it would be great helpful.
Thanks,
Tony Chain
Please remember to mark the replies as answers if they help and unmark them if they provide no help
November 24th, 2010 9:20pm