Solved

Reporting services creating invoice limiting the rows on each page

Posted on 2010-09-01
6
1,023 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
Space-Age Communications Transitions to DevOps

ViaSat, a global provider of satellite and wireless communications, securely connects businesses, governments, and organizations to the Internet. Learn how ViaSat’s Network Solutions Engineer, drove the transition from a traditional network support to a DevOps-centric model.

 

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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SSRS Expression 2 47
SSRS Problems 9 101
SSRS String Manipulation 6 49
Q2. How to run DAX query from SSMS. I don’t see any DAX query type. 1 71
Introduction: This article is aimed at report developers who are used to developing reports using relational databases and have gotten a first-time assignment to develop reports on OLAP cubes. It demonstrates how to build a report using SQL Ser…
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…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

685 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