Solved

SSRS 2005 lines per page

Posted on 2011-09-26
15
574 Views
Last Modified: 2012-05-12
I am trying to adjust my SSRS report to print only 10 lines per page. I am using this expression on a new group I added and putting this as the Group On Expression.

=Floor((RowNumber(Nothing) - 1) / 10)
When I go to preview the report I get this error message.

A group expression for the table ¿¿ uses the RowNumber function with a scope parameter that is not valid

The dataset name is RFQDetail. Do I need to add the dataset name to this expression. If so, what is the correct syntax?
0
Comment
Question by:rwheeler23
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 8
  • 6
15 Comments
 
LVL 9

Accepted Solution

by:
edlunad earned 400 total points
ID: 36602231
Try it like this...

=Floor((RowNumber("RFQDetail") - 1) / 10)  
0
 

Author Comment

by:rwheeler23
ID: 36602432
This does not work either. I get the same message. I added a second group. Do I need to somehow associate this group with the RFQDetail dataset?
0
 
LVL 9

Expert Comment

by:edlunad
ID: 36602527
I don't thing so, your table should be already pointing to your dataset.

Try using Ceiling instead of Floor...

=Ceiling(RowNumber(Nothing)/10)
0
Turn Insights into Action

Communication across every corner of your business is essential to increase the velocity of your application delivery and support pipeline. Automate, standardize, and contextualize your communication processes with xMatters.

 

Author Comment

by:rwheeler23
ID: 36629467
What it wanted was the table name.

RFQDetail was the dataset name and the table name was table1
This works:  =Ceiling(RowNumber("table1")/10)

Thanks fopr your help.
0
 

Author Comment

by:rwheeler23
ID: 36662603
One last question on this. Let's say there are 12 lines to print so 10 lines print on the first page and 2 lines print on the second page. Unfortuantely the report is skipping to a third page and printing the footer as opposed to printing the footer at the bottom of the second page. Is there any way to stop that?
0
 
LVL 4

Assisted Solution

by:anandarajpandian
anandarajpandian earned 100 total points
ID: 36710066
Please attached image,it may help you
select report footer property and
 unselect print on lastpage check box.

regards
anandaraj
Footerproperty.bmp
0
 
LVL 9

Expert Comment

by:edlunad
ID: 36710177
Sound like a page break in some of the items, be sure that your table doesn't have enabled any "Page break options"
0
 

Author Comment

by:rwheeler23
ID: 36710791
I have attached a copy of this report. I have been swapping options and not having any success. All I want is a header and then a fixed set of lines and the footer. The last stumbling point is the footer. It always goes to a separate page. I would be eternally greatful is someone could show me how to fix this.

Are there any sites that have sample SSRS that would illustrate how to do this?
Print-RFQs.rdl
0
 
LVL 9

Expert Comment

by:edlunad
ID: 36711200
Your Table1_Group1 contains a Page Break at the end of the group
pagebreak.PNG
0
 

Author Comment

by:rwheeler23
ID: 36711288
You are lookng at this using SQL 2008 and I ahve 2005. This is my screenshot not showing the page break. I am looking in the wrong location for the page break?
PageBreak.jpg
0
 

Author Comment

by:rwheeler23
ID: 36711309
Here is a better shot.
PageBreak.jpg
0
 
LVL 9

Expert Comment

by:edlunad
ID: 36711379
Was this happening from the beginning or after you added the 10 line break?
0
 

Author Comment

by:rwheeler23
ID: 36711562
Only after I added the 10 lines per page. I could take it but it would look better if each page always had the same number of lines.
0
 

Author Comment

by:rwheeler23
ID: 36711564
Maybe I should simply start this entire report over!!!
0
 
LVL 9

Assisted Solution

by:edlunad
edlunad earned 400 total points
ID: 36711731
I don't know were did you put the Ceiling expression but try moving it into Table1_Group1, below this line...

=Fields!VENDOR_NUMBER_IVRL.value
0

Featured Post

Increase Agility with Enabled Toolchains

Connect your existing build, deployment, management, monitoring, and collaboration platforms. From Puppet to Chef, HipChat to Slack, ServiceNow to JIRA, Splunk to New Relic and beyond, hand off data between systems to engage the right people.

Connect with xMatters.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Written by Valentino Vranken. Introduction: In a previous article (http://www.experts-exchange.com/articles/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Reporting-On-Data-From-Stored-Procedures-part-1.html) I announced that I would writ…
Hi, I have heard from my friends that it’s not possible to create Label Printing report using SSRS. I am amazed after hearing this words not possible in SSRS. I googled lot and found that it is possible to some of people know about the Report Bui…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…

696 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question