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?
”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
-Mike Kapnisakis, Warner Bros
With your subscription - you'll gain access to our exclusive IT community of thousands of IT pros. You'll also be able to connect with highly specified Experts to get personalized solutions to your troubleshooting & research questions. It’s like crowd-sourced consulting.
We can't always guarantee that the perfect solution to your specific problem will be waiting for you. If you ask your own question - our Certified Experts will team up with you to help you get the answers you need.
Our certified Experts are CTOs, CISOs, and Technical Architects who answer questions, write articles, and produce videos on Experts Exchange. 99% of them have full time tech jobs - they volunteer their time to help other people in the technology industry learn and succeed.
We can't guarantee quick solutions - Experts Exchange isn't a help desk. We're a community of IT professionals committed to sharing knowledge. Our experts volunteer their time to help other people in the technology industry learn and succeed.