SSRS 2005 lines per page

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?
rwheeler23Asked:
Who is Participating?
 
edlunadConnect With a Mentor Commented:
Try it like this...

=Floor((RowNumber("RFQDetail") - 1) / 10)  
0
 
rwheeler23Author Commented:
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
 
edlunadCommented:
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
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

 
rwheeler23Author Commented:
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
 
rwheeler23Author Commented:
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
 
anandarajpandianConnect With a Mentor Commented:
Please attached image,it may help you
select report footer property and
 unselect print on lastpage check box.

regards
anandaraj
Footerproperty.bmp
0
 
edlunadCommented:
Sound like a page break in some of the items, be sure that your table doesn't have enabled any "Page break options"
0
 
rwheeler23Author Commented:
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
 
edlunadCommented:
Your Table1_Group1 contains a Page Break at the end of the group
pagebreak.PNG
0
 
rwheeler23Author Commented:
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
 
rwheeler23Author Commented:
Here is a better shot.
PageBreak.jpg
0
 
edlunadCommented:
Was this happening from the beginning or after you added the 10 line break?
0
 
rwheeler23Author Commented:
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
 
rwheeler23Author Commented:
Maybe I should simply start this entire report over!!!
0
 
edlunadConnect With a Mentor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.