Sql Reporting Services

[member27]

Hi all, Iam Using Sql reporting Services and I want to keep a page break for each 10 records in a group...from 11 th record it should come in next page...How to do tat..i gave searched in net and wrote a expression in formula field of group Int((RowNumber(Nothing)-1)/1)..it is displaying only one record in each page .. how to do tat??Can anyone Help me..

[Wendelius]

If you're using Tablix you could try to modify your formula to define page break point to something like: =Ceiling(RowNumber(Nothing) / 10)

The need to optimize rises from a bad design.My articles[^]

[member27]

I gave the formula in page break ..but also it is displaying only one record in eachpage

[Ben Fair]

Try this one... =(RowNumber(Nothing) - (RowNumber(Nothing) Mod 10)) / 10 It should produce a group number for each 10 records; it's basically the same as DivRem, but since DivRem requires a variable by reference to hold the remainder I don't know of a way to use it in SSRS. Anyhow, for records 1 - 10 this should produce 1, 11 - 20, 2, etc. RowNumber(Nothing) Mod 10 gives you the remainder, in this case the number in the ones position (if it's RowNumber 24, it will give you 4) which you then subtract from row number to give you the tens position (24 - 4 = 20) which is then divided by 10 to give the group number (20 / 10 = 2).

Keep It Simple Stupid! (KISS)

[Ben Fair]

One other thing, I've never done this before so I cannot say for sure that you can do it in SSRS. If you cannot get it to work; add a column to your result set to hold the group number and populate it in the query that produces the data and then just group on the group number column in the report. I've had to use that approach for other complex things that I just couldn't get to work directly in the SSRS report.

Keep It Simple Stupid! (KISS)

[member27]

Ok thank u..I tried using tat formula..But it is displaying one record in every page...