Using tablix control in SSRS

See more:

SSRS

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 challenging part here is, I need to insert a textbox in the middle of every 10 rows and the textbox must have the summary of the 10 rows from the table above.

Can someone 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 reference links?

Thanks in Advance