sql server reporting services: I found this expression for implementing a pagebreak. I don't know where in
the report to place it.

System.Math.Ceiling (RowNumber (Nothing)/10)

I have a table in the detail section of my report. 3 rows 3 columns, a
header row, a data row and a footer row. The data row obviously contains an
expression to link each cell with the respective field from the dataset.
There are 50 rows in the dataset. I want to display 10 rows per page, thus
the expression above. But where do I place this expression? Any suggestions
appreciated.

Thanks,

Insert a group in the Table and in expresson mention
= System.Math.Ceiling (RowNumber (Nothing)/10)
Select the "Page break at end" option and run the report.
You will get the desired output.

Regards,

Insert a group in the Table and in expresson mention
= System.Math.Ceiling (RowNumber (Nothing)/10)
Select the "Page break at end" option and run the report.
You will get the desired output.

Regards,

Thanks. That worked perfectly!

[quoted text, click to view]