HI i had a suggestion on doing some job where i need to show a table with 10 rows and a bottom of that table a textbox with the summary of all the data in table with 10 rows , the dataset i am using for that table has 100 records, what i have to do here is i have to give a page break after every 10 rows and rest of rows should be in other pages ,the challangeing part here is i need to insert a text box in the middle of every 10 rows and have the taxtbox box must have the sumamry of the 10 rows from the table above , can some one suggest me how to do that ,should i get the data on the basis of 10 rows or can i do something in the RDl , can some one please provide me some refrence links Thnaks in Advance

Hi Raju9789, According to your description, you would like to display 10 rows one page and a textbox behind the table. I suggest that you could use List to achieve your target. Generally speaking, we could use List to fix the number of rows that show on a page, and then put a textbox behind the table inside the list. Please refer to the following steps for your reference. 1. Insert a List to your design surface. 2. Select the List, right-click the Details in the Row Groups which is located on the left bottom. 3. Select Group Properties, click “fx” button at the right of the “Group on” label. 4. Type in the expression: =Ceiling(Rownumber(nothing)/10) Note: 10 is a number of rows that you want to display on a page, you could define it by your requirement. 5. Lay the table into the list and then drag a textbox behind it. 6. Add a page break to the table inside the list. After you complete those steps, there is 10 records every page with a textbox behind the table. For more information about How to: Add a Page Break (Reporting Services), please see: http://msdn.microsoft.com/en-us/library/ms156434.aspx Thanks, Challen FuPlease remember to mark the replies as answers if they help and unmark them if they provide no help.

Hi Raju9789, According to your description, you would like to display 10 rows one page and a textbox behind the table. I suggest that you could use List to achieve your target. Generally speaking, we could use List to fix the number of rows that show on a page, and then put a textbox behind the table inside the list. Please refer to the following steps for your reference. 1. Insert a List to your design surface. 2. Select the List, right-click the Details in the Row Groups which is located on the left bottom. 3. Select Group Properties, click “fx” button at the right of the “Group on” label. 4. Type in the expression: =Ceiling(Rownumber(nothing)/10) Note: 10 is a number of rows that you want to display on a page, you could define it by your requirement. 5. Lay the table into the list and then drag a textbox behind it. 6. Add a page break to the table inside the list. After you complete those steps, there is 10 records every page with a textbox behind the table. For more information about How to: Add a Page Break (Reporting Services), please see: http://msdn.microsoft.com/en-us/library/ms156434.aspx Thanks, Challen Fu Please remember to mark the replies as answers if they help and unmark them if they provide no help. hi thx for the answer, another question is is there any way i can get two tables side by side like left side and right side of report body with 10 rows in left table and 10 rows in righ table from the same dataset ? can we do somethibng like that

Hi Raju9787, You could also achieve this requirement in reporting services, just copy another table then lay it beside first one. Open first table's group properties move to visibility tab, set this expression =IIF(Rownumber(nothing) mod 2 =0, true, false) to control table row's visibility. Open second table's group properties move to visibility tab, set this expression =IIF(Rownumber(nothing) mod 2 =1, true, false) to control table row's visibility. Change list's group expression to =Ceiling(Rownumber(nothing)/20)Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Hi Raju9787, You could also achieve this requirement in reporting services, just copy another table then lay it beside first one. Open first table's group properties move to visibility tab, set this expression =IIF(Rownumber(nothing) mod 2 =0, true, false) to control table row's visibility. Open second table's group properties move to visibility tab, set this expression =IIF(Rownumber(nothing) mod 2 =1, true, false) to control table row's visibility. Change list's group expression to =Ceiling(Rownumber(nothing)/20) Please remember to mark the replies as answers if they help and unmark them if they provide no help. Thanks , and onemore thing is what am i supposed to do if i have one table with 100 rows in it when i export it to pdf its like 5 pages , can i get that side by side like same left 10 rows and right 10 rows ,can i do like that using one table or should i use two tables and write some sort of expression to get the rows divided in to two tables like 50 in one table and 50 in other

Thanks , and onemore thing is what am i supposed to do if i have one table with 100 rows in it when i export it to pdf its like 5 pages , can i get that side by side like same left 10 rows and right 10 rows ,can i do like that using one table or should i use two tables and write some sort of expression to get the rows divided in to two tables like 50 in one table and 50 in other Hi Raju9789, Have you tried my second reply? it is just the steps for this requirement. You should make use of two tables in a list control, hide first table's even number of records, hide second table's odd number of records. Lastly, you should follow below to add a pagebreak to the list. In the Grouping pane, right-click a details group, and then click Group Properties. On the Page Breaks tab, select Between each instance of a group. Then there are two table side by side on one page. If you have any question about the steps, please feel free to ask. Thanks, ChallenFuPlease remember to mark the replies as answers if they help and unmark them if they provide no help.

Thank you!!! I have been looking for this everywhere and this is the only answer. :-)

Thank you!!! I have been looking for this everywhere and this is the only answer. :-)