Solved

SSRS 2005 lines per page

Posted on 2011-09-26
15
567 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
Comment Utility
Try it like this...

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

Author Comment

by:rwheeler23
Comment Utility
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
Comment Utility
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
 

Author Comment

by:rwheeler23
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
Sound like a page break in some of the items, be sure that your table doesn't have enabled any "Page break options"
0
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 

Author Comment

by:rwheeler23
Comment Utility
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
Comment Utility
Your Table1_Group1 contains a Page Break at the end of the group
pagebreak.PNG
0
 

Author Comment

by:rwheeler23
Comment Utility
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
Comment Utility
Here is a better shot.
PageBreak.jpg
0
 
LVL 9

Expert Comment

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

Author Comment

by:rwheeler23
Comment Utility
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
Comment Utility
Maybe I should simply start this entire report over!!!
0
 
LVL 9

Assisted Solution

by:edlunad
edlunad earned 400 total points
Comment Utility
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

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

After much searching across the internet I have found that you could not set the name of the file you were attaching to dynamic report subscriptons in Microsoft Reporting Services. I did manage to find one article showing you how your could make a s…
It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss.  This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in.  And this behavior is only see…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

728 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

10 Experts available now in Live!

Get 1:1 Help Now