Hi, I have a report which contains the company and other details on half of the page, after that there is a table my table must be break after 20 rows and then sub-total and remaining all the records move to next page onwards on group of 40 rows every page. Means to say first group is after 20 rows and remaining group must be of 40 rows in a single table.

Hi Srikanth, Try like below 1: Create a group with the expression like =cint(RowNumber(Nothing)-1)<20 and check the checkbox in Page Break and delete the sorting column 2: Now delete the column which added in tablix after creating group 3: Right click on Details section and insert row Insert Group- Below 4: Sum(Fields1.Value) for sub-total

Hi Venkata, Thanks for the support but 2nd point tell to delete about the column but there is no any column added when i group by details selection in the tablix. i have done this earlier also but it will group the table after 20 rows in first page and this is fine. But i also want from second page table group after every 40 rows till last.

Hi Srikant, Generally, we can only refer to page number in the page header/footer, so in the group on expression, we cannot control the number of rows dynamically. However, one possible workaround is to use 2 tables, one for the first 20 rows and the other for remaining rows. Please refer to the steps below: 1. Add the first table to the report, and specify data fields to cells in the detail row. 2. Select the handle of the detail row. In the Visibility\Hidden property, specify the expression =(RowNumber(Nothing)>20) 3. Right click the handle of the table, select Properties. In Table Properties dialog, check the option Insert a page break after this table. 4. Add the second table, and also specify data fields to cells in the detail row. 5. Select the handle of the detail row. In the Visibility\Hidden property, specify the expression =(RowNumber(Nothing)<=20) 6. Right click the handle of the second table, select Insert Group. Specify the Group on expression to =Ceiling((RowNumber(Nothing)+20)/40), and also check the option Page break at end. If anything is unclear, please feel free to ask. Thanks, Tony ChainTony Chain [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.