Solved

Reporting services creating invoice limiting the rows on each page

Posted on 2010-09-01
6
1,018 Views
Last Modified: 2012-06-27
Can anyone give me an example or a step by step of how to do this in ssrs 2008 ?

I have seen loads of posts saying use =Int((RowNumber(Nothing)-1)/25),I have tried it on a group but cant seem to get it working.

Any help appreciated
0
Comment
Question by:martin05
  • 4
  • 2
6 Comments
 
LVL 12

Accepted Solution

by:
mcv22 earned 500 total points
ID: 33579907
0
 

Author Comment

by:martin05
ID: 33580421
tried that

added a table to my page
created a group
entered the expression

returns aboit 400 rows per page
then if you add page breaks it returns one single record each time.

I really need an idiots guide !
0
 
LVL 12

Expert Comment

by:mcv22
ID: 33580459
Did you try changing the page height as described in the comments below?
0
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 

Author Comment

by:martin05
ID: 33580655
I did but it doesnt make any difference Im either getting all the rows or 1 row per page based on adding page breaks
0
 

Author Comment

by:martin05
ID: 33588865
Right the link above did kinda solve my problem although I had to put my table in a list and work it that way.
0
 

Author Closing Comment

by:martin05
ID: 33588880
as i said on my last post
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
receive report server error 9 67
SSRS report 5 44
SSRS UK Map with Postcodes 2 70
SSRS Dynamic Date Parameter 25 149
In this short article I will be talking about two functions in the SQL Server Reporting Services (SSRS) function stack.  Those functions are IIF() and Switch().  And I'll be showing you how easy it is to add an Else part to the Switch function. T…
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…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

759 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

20 Experts available now in Live!

Get 1:1 Help Now