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

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

Other recent topics Other recent topics