We help IT Professionals succeed at work.

SSRS:  Subreport Does Not Display Correctly in the Main Report

Last Modified: 2014-01-22

Attached are .rdl files.  One is my main report, while the other other is my subreport.  The main report's name is a misnomer as I entitled it "POOR_RCG_Subreport.rdl".  But, it is the main report and not a subreport.  It's a long story.

Anyway, the subreport is showing the correct dollar figure, when run.  But, when I run the main report containing this subreport, the dollar figure is incorrect.

The dollar figure is $3,050,630.  This is showing correctly in the subreport.  But, when the subreport is placed in the main report, the dollar figure instead shows as $669,749.

What's happening is that the subreport in the main report is taking the dollar figure from the first record in the main report.  Instead, I simply want the dollar figure from the subreport to show in the main report without being "influenced" by data on the main report.

Can someone please take a look and let me know how to fix this, so that the subreport displays the correct dollar value in the main report?

Thanks!  Much appreciated!

Watch Question


Why are you running a subreport just for totals?
It should be in the main report.


The subreport is an offshoot of another subreport.  It's a long story.  

The main reason is that I cannot "combine" the programming of the main and subreport.

Again, long story short, I need this separate subreport just the way it is.  And, I need to make this all happen ASAP, since I'm on a tight deadline with this customer.

This one is on us!
(Get your first solution completely free - no credit card required)


This solution gave our customer exactly what they wanted in the report.

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.


Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.