Solved

SSRS Report - Records Appearing Multiple Times on Different Pages

Posted on 2013-10-29
5
556 Views
Last Modified: 2013-10-31
When I run my report it displays the records in x number of pages depending on the grouping of a field called billing number. So if I have 2 projects it will repeat all the records on 2 pages. If I have 4 projects it will repeat all records on 4 pages. How to fix this so only the records belonging to the billing number are visible on that page?
0
Comment
Question by:mathew_s
  • 2
5 Comments
 
LVL 12

Expert Comment

by:Koen Van Wielink
Comment Utility
Can you provide your RDL, or at the very least a screenshot of your design? Very hard for us to figure out what's going on without some more details.
0
 
LVL 23

Accepted Solution

by:
Rajkumar Gs earned 500 total points
Comment Utility
Hi Mathew

I doubt whether you have used the Header section ? Since it repeats in all pages
Pls check

Raj
0
 
LVL 1

Author Comment

by:mathew_s
Comment Utility
Yes something was wrong in the header, I was getting an error there. Once I fixed that everything seemed to go into place.
0
 
LVL 23

Expert Comment

by:Rajkumar Gs
Comment Utility
Great :)
0

Featured Post

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

Join & Write a Comment

Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
A recent question popped up and the discussion heated up regarding updating a COMMENTS (TXT) field in a table using SSRS. http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Q_27475269.html?cid=1572#a37227028 (htt…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

762 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

9 Experts available now in Live!

Get 1:1 Help Now