Report, Change The Number Of Rows Per Page

I am fairly new to reporting services and recently created a simple tabular report. There is one table which queries the database and I would like to change the table so there are more than 25 rows of data per page. How do I do this?

Also it would be advantageous to know how to set the report to only create a new page for every different item in a column. For eg if I have various data for each date, I would like to only create a new page when the date changes so that all data for a specific date is on one page etc etc.

Many Thanks

May 29th, 2008 8:54am

Hello,

You can create new page for each new date by following the above steps:

  1. Right click on DateGroup and Select Edit group
  2. Now Check the Page Break at end checkbox.
  3. Click on OK.

Free Windows Admin Tool Kit Click here and download it now
May 29th, 2008 9:07am

Hello,

By writing thecustom code also we can solve your issue:

Dim RowNumber as Integer

Dim RowGroupNumber as Integer

Dim PrevCustomerNumber as String

Public Function GetRowGroupNumber(Date as String) as Integer

If (RowNumber =n and (PrevDate <> CurrentDate) ) then

RowGroupNumber = RowGroupNumber +1

RowNumber = 0

End if

If PrevDate <> CurrentDate then

RowNumber = RowNumber +1

End if

PrevDate = CurrentDate

GetRowGroupNumber = RowGroupNumber

End Function.

Hope this solves your problem

May 29th, 2008 9:48am

When you click page break at end this does put a page break in however it also puts a page break every 25 rows.


Many Thanks
Free Windows Admin Tool Kit Click here and download it now
May 29th, 2008 10:43am

Hi,

To pagebreak after a specific number of rows, you need to use a grouping with a PageBreakAtEnd property. For your grouping expression, use a count running value to derive a unique group value for each block of N rows.

For example:
Code Snippet=Ceiling (RowNumber (Nothing)/20)

Hopefully this helps

June 3rd, 2008 10:37am

What I'm trying to do is to extend the number of rows from 25 to say 50 for eg, the pages always breaks at 25. My goal is to page break when a date changes in the date column therefore having all data on each page for each date.

Free Windows Admin Tool Kit Click here and download it now
June 3rd, 2008 11:01am

You can create a group which is grouped on the data value in the dataset and have a page break at the end of this group.

Also, make sure that the size of the page is large enough.

Thanks.

June 9th, 2008 6:04am

 

 

I can't get this to work. Should the "Nothing" be replaced with the name of the grouping region?

 Yao-Jie Tang - MSFT wrote:
 Hi,

 

To pagebreak after a specific number of rows, you need to use a grouping with a PageBreakAtEnd property.  For your grouping expression, use a count running value to derive a unique group value for each block of N rows. 

For example:

 

Hopefully this helps

Code Snippet  =Ceiling (RowNumber (Nothing)/20)

 

 

 

 

Free Windows Admin Tool Kit Click here and download it now
June 18th, 2008 2:15am

hi,

i am facing similar problem,

i tried PageEndBreake...but it shows that only one group per page...

but my problem is to restrict number of rows per page..

Thanx in advance,

Sagar Joshi

August 30th, 2010 1:23pm

Hi all,

I am facing a similar problem in my report.  My report contains a table (Table1) listing employees (Details) by department (Group1).  I would like to add a new page break after each 10 records within a group.

Current example:

MENSWEAR
G1Employee1
G1Employee2
...
G1Employee24
<page break>

WOMENSWEAR
G2Employee1
G2Employee2
...
G2Employee16
<page break>


What I would like to achieve:

MENSWEAR
G1Employee1
G1Employee2
...
G1Employee10
<page break>

MENSWEAR
G1Employee11
G1Employee12
...
G1Employee20
<page break>

MENSWEAR
G1Employee21
G1Employee22
...
G1Employee24
<page break>

WOMENSWEAR
G2Employee1
G2Employee2
...
G2Employee10
<page break>

WOMENSWEAR
G2Employee11
G2Employee12
...
G2Employee16
<page break>

Now as suggested above I tried adding in an extra Grouping with a PageBreakAtEnd above my existing group.  This new grouping used the following expression:

=CEILING(RowNumber(NOTHING)/10)

But all I am getting is the following:

MENSWEAR
G1Employee1
G1Employee2

WOMENSWEAR
G2Employee1

DEPARTMENT1
D1Employee1
D1Employee2
D1Employee3

DEPARTMENT2
D2Employee1
D2Employee2

DEPARTMENT3
D3Employee1
D3Employee2
D3Employee3
<page break>

MENSWEAR
G1Employee3
G1Employee4

WOMENSWEAR
G2Employee2

... and so on.

I hope that all makes sense.

 

 

 

 

Free Windows Admin Tool Kit Click here and download it now
October 6th, 2010 1:21am

Hi, In your case, You want to group your dataset by the date, and then, go to the "group properties" and under "Page Breaks", check only the top option: "Between each instance of a group". when you preview, you should see all the rows on one page with the same date. Unless the number of records or rows exist the amount that can fit in one page, then it will be on the 2nd page. Hope this helps..

September 11th, 2015 4:45pm

Hi,

Unfortunately, SSRS does not allow you to control the number of rows if you have existing grouping. The only way around is to use a parameter.  This would prompt the user to enter the desired number of rows to show on each page.

Free Windows Admin Tool Kit Click here and download it now
September 11th, 2015 4:51pm

Here's the example:

1. Create a parameter (datatype = integer)

2. Specify a default value (i.e. 10)

3. Go to Group properties and write this expression:

 =Ceiling(RowNumber(Nothing)/Parameters!RowNumber.Value)

September 11th, 2015 5:02pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics