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 Wednesday, December 8, 2010 9:02 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,

In 2005 I'm able to do this as mentioned earlier, but the problem is with 2008 .

I have followed the steps you have mentioned.

The sorting tab also was showing the same expression = Ceiling(Rownumber(Nothing)/10) ,then I have removed it.

And completed the steps given by you.

But I'm getting an error as below:

"
The Value expression for the tablix ‘Tablix7’ contains an error: [BC30654] 'Return' statement in a Function, Get, or Operator must return a value.
"






Thanks & Regards,
MC
Post #1031958
Posted Wednesday, December 8, 2010 10:46 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, September 10, 2014 11:26 AM
Points: 1,596, Visits: 6,629
only4mithunc (12/8/2010)
Hi Peter,

In 2005 I'm able to do this as mentioned earlier, but the problem is with 2008 .

I have followed the steps you have mentioned.

The sorting tab also was showing the same expression = Ceiling(Rownumber(Nothing)/10) ,then I have removed it.

And completed the steps given by you.

But I'm getting an error as below:

"
The Value expression for the tablix ‘Tablix7’ contains an error: [BC30654] 'Return' statement in a Function, Get, or Operator must return a value.
"




I guess you did not remove the sort expression but just cleared the expression value (leaving the '=' behind). On the Sorting tab select the entire row for the sort expression (by clicking the 'Sort by' text) and then click the Delete button.

Peter
Post #1032039
Posted Wednesday, December 8, 2010 7:09 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
Thank you so much Peter,

Yes you are correct I have done it like that, leaving the "=" sign there, now I have deleted the entire row then it worked!!!!

One more small question, now at the left most side of the report I can see that Grouping column, and in each page it will show 1-10 as I have 10 pages. As I don't want to show this column I have selected that column and visibility property is made to false, now it is not showing but when I export to excel, in each page I can see that blank column.

Can we do something (rather than making the column width very very small ? ) so that this blank column wont come in the report out put as well as while exporting to excel?



Thanks & Regards,
MC
Post #1032252
Posted Wednesday, December 8, 2010 11:21 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, September 10, 2014 11:26 AM
Points: 1,596, Visits: 6,629
Why not just remove the column? Right click on the column header, select 'Delete Columns', select 'Delete columns only'.

Peter
Post #1032304
Posted Thursday, December 9, 2010 6:23 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
Thats correct

Thanks Peter, one more question, in the tablix property I have checked the "Repeat row header , Repeat column header " but the Column header is coming only in the firs page...

Should I do the settings some where else.. ?



Thanks & Regards,
MC
Post #1032413
Posted Thursday, December 9, 2010 8:49 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, September 4, 2014 11:45 AM
Points: 2,819, Visits: 2,562
Right below the main design window pane is a small pane called the grouping pane. On the right side of the grouping pane is a small drop down arrow, click it and choose advanced. This will show all the row groupings in a graphical format. Choose the appropriate row group and then set its property to RepeatOnNewPage.
Post #1032500
Posted Thursday, December 9, 2010 9:30 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
Thanks Daniel,

When I tried the option you have mentioned it worked, with making "Keep With Group " Option = After

Can I know what is the significance of "Keep With Group" property?



Thanks & Regards,
MC
Post #1032539
Posted Thursday, December 9, 2010 2:00 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, September 4, 2014 11:45 AM
Points: 2,819, Visits: 2,562
I believe the Keep with group is supposed to keep groups of data together on a page when possible. For example if you had a group that was order information and a detail section with the details of the order such as products and price. Keep with group is supposed to keep the group and the detail together on a page to make reading the report easier.
Post #1032727
Posted Thursday, December 9, 2010 8:01 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
Thanks Daniel,

Why I asked was , when I make "Keep With Group " = Before/None , the column header was not repeasting to all the pages, it was comming only in the first page, but when I made it "After" , the header was comming in each pages...

Is this is the it works? Or do you think I made some mistakes so where?



Thanks & Regards,
MC
Post #1032812
Posted Friday, December 24, 2010 3:32 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, April 22, 2011 4:11 AM
Points: 1, Visits: 64
good solution it works
Group on
=Ceiling(RowNumber(nothing)/3)

Set the group page break property
Post #1039073
« Prev Topic | Next Topic »

Add to briefcase «««12345»»»

Permissions Expand / Collapse