Solved

SSRS 2005 lines per page

Posted on 2011-09-26
15
568 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
  • 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
DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

 

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

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SSRS reports 5 32
the over sql construct is not supported 3 65
Date Differences SSRS 3 65
How to connect Power BI Desktop to ssrs report server 2 23
Steps to solve SSRS SQL 2008 R2 User Access Control (UAC) Permission Error With the introduction of SQL Server 2008 R2 and Vista (Windows 7 as well) came new enhanced security features. One of the features included was User Access Control (UAC) t…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…

815 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now