• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1245
  • Last Modified:

SSRS: Subreport Does Not Display Correctly in the Main Report

Hello:

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!

TBSupport
POOR-RCG-Subreport.rdl
POOR-RCG-Detail-Subreport3.rdl
Subreport-Problem.docx
0
TBSupport
Asked:
TBSupport
  • 3
1 Solution
 
planoczCommented:
Why are you running a subreport just for totals?
It should be in the main report.
0
 
TBSupportAuthor Commented:
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.

TBSupport
0
 
TBSupportAuthor Commented:
Hello:

Yesterday, I figured this out, just now, on my own.  Instead of placing the subreport in the main report, I mimicked the subreport by creating a new "second main report".

So, you may close this case out.  My solution is the correct one, ultimately.

Thanks!

TBSupport
0
 
TBSupportAuthor Commented:
This solution gave our customer exactly what they wanted in the report.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

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.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now