Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12345»»»

Reporting Services - Limiting Records Per Page Expand / Collapse
Author
Message
Posted Friday, October 30, 2009 2:24 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, May 31, 2012 7:14 AM
Points: 22, Visits: 152
I am trying in Ssrs 2008 but when i used Ceiling(Rownumber(Nothing)/10) it displayed only one row in the report am i doing anything wrong(i have 12 rows)
Post #811862
Posted Monday, May 31, 2010 1:23 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, June 10, 2010 12:22 AM
Points: 10, Visits: 26
I am trying the same expression as suggested int he forum to restrict number of records per page to 20. But it does not work. Still it displays 55 records per page.
Post #930252
Posted Tuesday, June 08, 2010 4:38 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, June 08, 2010 4:35 PM
Points: 1, Visits: 6
I am using the following as you suggested successfully.

Floor((RowNumber(Nothing) - 1) / Parameters!RowsPerPage.Value)

However, adding this grouping broke the interactive sort that we had in place. The sort currently only sorts those records within each page.

Any suggestions?
Post #934315
Posted Tuesday, August 24, 2010 4:39 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, October 18, 2012 12:27 AM
Points: 83, Visits: 473
Hey it's great to restrict the number of rows per page

I have one problem.i need to restrict the number of pages for report.

I have 100 pages report but my client want only first 20pages, for some reports he want last 20 pages.
how can do that???????????



thanks in advance
sank
Post #973996
Posted Tuesday, August 24, 2010 5:59 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 6:12 AM
Points: 10,910, Visits: 12,553
Sank,

You may want to create a new thread for this question as it is a bit different than the main question on this page.


I don't know how to do what you are being asked to do with reporting services. Will the client only ever want the first 20 or last 20 pages? What determined what is first and what is last? Is there a way of summarizing the data that reduces the # of pages yet still provides the necessary information? Honestly, I can't really imagine a case where a 100 page report is useful so I'm of the opinion that the client needs to rethink what they really want and need in this case.




Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Post #974040
Posted Monday, December 06, 2010 10:03 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, February 20, 2013 9:40 AM
Points: 358, Visits: 2,775
Hi friends,

I have tried the expression as mentioned above

= Ceiling(Rownumber(nothing)/10)) this worked perfectly in SSRS 2005.

But can some please let me know how to do it in SSRS 2008? There when I right lick the table, it is showing column group and row group separately.




Thanks & Regards,
MC
Post #1030718
Posted Tuesday, December 07, 2010 10:45 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, February 20, 2013 9:40 AM
Points: 358, Visits: 2,775
Hi All,

I have tried many options in SSRS 2008 to do this but no luck.. :-(

Can some one help me on this please...



Thanks & Regards,
MC
Post #1031656
Posted Wednesday, December 08, 2010 3:24 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 4:27 AM
Points: 1,592, Visits: 6,523
You can add a row group with a break on the RowNumber expression. However, you have to remove the breaking expression from the Sorting options (the group expression is automatically added to the sorting option).

Peter
Post #1031748
Posted Wednesday, December 08, 2010 6:56 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, February 20, 2013 9:40 AM
Points: 358, Visits: 2,775
Hi Peter Thanks for your reply.

It didn't work.

This is what I have tried:

1) In my tablix selected the detail row
2) Right Click --> RowGroup--> Group Properties
3) In General tab, for Group Expression I have give as

=Ceiling(Rownumber(Nothing)/10)

After this when I checked nothing happened, all the records are coming as usual.

4)Then in the Page Break tab I checked the check box " Between Each Instance of the Group "

But after this records came 1 in one page like 100 pages !! as I have total 100 records.

Is the steps what I tried is correct? If not could you please correct me...



Thanks & Regards,
MC
Post #1031852
Posted Wednesday, December 08, 2010 7:21 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 4:27 AM
Points: 1,592, Visits: 6,523
only4mithunc (12/8/2010)
Hi Peter Thanks for your reply.

It didn't work.

This is what I have tried:

1) In my tablix selected the detail row
2) Right Click --> RowGroup--> Group Properties
3) In General tab, for Group Expression I have give as

=Ceiling(Rownumber(Nothing)/10)

After this when I checked nothing happened, all the records are coming as usual.

4)Then in the Page Break tab I checked the check box " Between Each Instance of the Group "

But after this records came 1 in one page like 100 pages !! as I have total 100 records.

Is the steps what I tried is correct? If not could you please correct me...

The problem you describe have been discussed earlier in this thread. Don't set the group expression on the Group Properties of the detail row. You really have to add a new row group to the detail row. Do the following:

1) add a parent group to the detail row (without header and footer).
2) set the group expression of the parent group to =Ceiling(Rownumber(Nothing)/10)
3) select the just added row group and remove the sorting expression in the Group Properties (on the Sorting tab)
4) in the Page Break tab check the check box " Between Each Instance of the Group

That should do.

Edit: added step to set page break
Post #1031874
« Prev Topic | Next Topic »

Add to briefcase ««12345»»»

Permissions Expand / Collapse