Hi I am a newbie to SSRS. I am working on SSRS Grouping. I haven't got any solution for the below issue. Please let me know if anyone know regarding the below issue. Thanks in advance. LEVEL 1 DATA LEVEL 2 DATA LEVEL 3 DATA I have a 3 Level Data, populated by grouping the data. Like above. Requirement is LEVEL 1 - Say ITEM CATEGORY LEVEL 2 - ITEM CATEGORY Description LEVEL 3 - ITEMS Now my Level 3 Data can be of more than one row. For few records, this may go upto 10 rows. Now the actual requirement is like this. If the Level 3 has more rows and this may print in the 2nd page. When Level 3 Data prints on the 2nd page, Level 1 data and Level 2 Data also gets printed out. Whcih I don't want. Only the Level 3 data needs to be printed out if there is more data. Example.(I want the report look like this) Page1 -------- ITEM CATEGORY1 ITEM DESCRIPTION 1 ITEM1 ITEM2 ITEM3 ITEM4 ITEM5 ITEM6 ITEM7 ITEM8 ITEM9 Page 2 --------- ITEM10 ITEM11 ITEM12 The current report design comes like this Page1 -------- ITEM CATEGORY1 ITEM DESCRIPTION 1 ITEM1 ITEM2 ITEM3 ITEM4 ITEM5 ITEM6 ITEM7 ITEM8 ITEM9 Page 2 --------- ITEM CATEGORY1 ITEM DESCRIPTION 1 ITEM10 ITEM11 ITEM12 Thanks Mohan Gajula http://iMohanG.blogspot.com

Kindly do check the option for Row Headers or Column headers 'Repeat the Header Rows in each page' or 'Repeat the Header Columns in each page' is ticked. If so do uncheck it and verify your output. Its the option above ll be found in tablix property of SQL 2008 If its not plz ignore this post. --------------------------- Radhai Krish | Golden Age is no more far | --------------------------

Uncheck the option "Repeat the Header Rows on each page" for groups category and description, and should be good. Thanks,

Hi Mohan, If you are using Reporting Services 2005, we can select the handle of the group header row, and then in the Properties grid, specify the RepeatOnNewPage property to False. If you are using Reporting Services 2008, in order to disable the repeat of group header, please refer to the steps below: 1. Select the table and specified the RepeatColumnHeader property to False. 2. In the Grouping pane (Row Groups and Column Groups), click on the small triangle in the top-right corner and select Advanced Mode to show static members. 3. Select the (static) item in the Row Groups hierarchy which is corresponding to the group header. 4. In the Properties grid, set RepeatOnNewPage to False and FixedData to False. For more information about Controlling Row and Column Headings in Reporting Services 2008, please see: http://msdn.microsoft.com/en-us/library/cc281227(v=SQL.100).aspx If you have any question, please feel free to ask. Thanks, Tony ChainPlease remember to mark the replies as answers if they help and unmark them if they provide no help

Thanks everyone but this has not resolved my problem. "RepeatHeaderRows" option is not set for me.Infact i do not have any header in my table. Tony , I am using 2008. I tried using your solution but has not resolved my problem. Infact the groups were set up as RepeatOnNewPage to False and FixedData to False. I have members shown as (static)-(Static) Indicates a static member with no header cell, known as a hidden static. The values of outer 2 groups are still repeated(on 2nd page) if the inner group data is continued on 2nd page.

Hi Mohan, Since it is hard to reproduce this scenario, could you please send the report file and sample data to the E-mail address below, and then I will try to resolve the issue. E-mail: sqltnsp AT microsoft.com (Please replace the AT with @, and remove additional spaces) Thanks, Tony Chain Please remember to mark the replies as answers if they help and unmark them if they provide no help

Thanks for the Reply. Issue got fixed by looking into the groups for each header.Mohan Gajula http://iMohanG.blogspot.com