Solved

Paging in SSRS

Posted on 2011-02-23
4
470 Views
Last Modified: 2012-05-11
I have a report that has a header and a body.  In the body is a single table.

The entire table pulls from a single query in the DB using a stored procedure.

I have tested the stored procedure and it returns appropriate data.

However, what I need is the report to page break after each record.  I cannot seem to make that happen.  What am I doing wrong?
0
Comment
Question by:JayFromPep
  • 2
  • 2
4 Comments
 
LVL 10

Accepted Solution

by:
itcouple earned 500 total points
Comment Utility
Hi

Not sure entirely about 2005... but in the design at the bottom you should have grouping and one of it should be "details" try going to properies and look for page break "after". If you cannot find left click details click F4 to go to properties pane and find page break or break.

Sorry for not very precise instructions.

Hope that helps.
Emil
0
 
LVL 5

Author Comment

by:JayFromPep
Comment Utility
hmm....not seeing the options there.

Are the settings in the image correct?



Listproperties.png
0
 
LVL 10

Expert Comment

by:itcouple
Comment Utility
Hi

From what I see you use list control (not table) and I would expect (from these settings) a page break after the list not for each row in the list control. Can you change it to table? You should get more control over it..... I think (I haven't used 2005 for a few years so I'm kind of guessing).

Regards
Emil
0
 
LVL 5

Author Comment

by:JayFromPep
Comment Utility
Emil,

Actually, I figured it out.  I had to create a details grouping.  I was expecting it to know that by default.  Once I created a details grouping, it worked fine with the list.

Thanks!
0

Featured Post

Highfive Gives IT Their Time Back

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!

Join & Write a Comment

Introduction In the following article I’ll be discussing and demonstrating several different ways of how images can be put on a report. I’m using SQL Server Reporting Services 2008 R2 CTP, more precisely version 10.50.1352.12, but the methods ex…
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

771 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

11 Experts available now in Live!

Get 1:1 Help Now