Solved

SSRS Report - Records Appearing Multiple Times on Different Pages

Posted on 2013-10-29
5
558 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
ID: 39610815
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
ID: 39610818
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
ID: 39611822
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
ID: 39615999
Great :)
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
PERFORMANCE OF SQL QUERY 13 66
Problem with SqlConnection 4 162
Table create permissions on SQL Server 2005 9 41
Urgent help needed! Unable to to paste in query designer 29 39
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…
In this article I will describe the Backup & Restore 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.
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
As a trusted technology advisor to your customers you are likely getting the daily question of, ‘should I put this in the cloud?’ As customer demands for cloud services increases, companies will see a shift from traditional buying patterns to new…

863 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

21 Experts available now in Live!

Get 1:1 Help Now