chuckcoleman
Registered User.
- Local time
- Today, 11:00
- Joined
- Aug 20, 2010
- Messages
- 357
OK, this is driving me nuts. I have a report. The main report has two sub reports. If I run the report with the two sub reports, everything displays correctly. See the screen shot below, highlighted in YELLOW. This is on the second page of a two page report. As a simple first step, if I put a text box on the main report that refers to a text box on one of the two sub reports, it changes the value of the text box on the sub report. The YELLOW highlighted number of $6,275 is now $695 in the sub
report and the new text box that I added in the main report is now $220.00 which happens to be the first line on the page, (this is page 2 of 2), circled in RED. My expectation is that the new text box on the main report would show $6,275. In the sub report, $6,275 is on the report footer and it "points" to a hidden text box in the detail section that has a running sum over all. In the main report the text box Control Source is: =[InvoiceSub Report].[Report]![GrandTotalX]. That text box is in the footer section of a field, JobID. There is only one JobID per report. I've also tried it in the Detail section with the same result.
What am I doing wrong? Once I get this fixed, in the second sub report where you see "Amount", I want it to pick up the $6,275. First things first, main form to sub form. Thanks, Chuck
report and the new text box that I added in the main report is now $220.00 which happens to be the first line on the page, (this is page 2 of 2), circled in RED. My expectation is that the new text box on the main report would show $6,275. In the sub report, $6,275 is on the report footer and it "points" to a hidden text box in the detail section that has a running sum over all. In the main report the text box Control Source is: =[InvoiceSub Report].[Report]![GrandTotalX]. That text box is in the footer section of a field, JobID. There is only one JobID per report. I've also tried it in the Detail section with the same result.
What am I doing wrong? Once I get this fixed, in the second sub report where you see "Amount", I want it to pick up the $6,275. First things first, main form to sub form. Thanks, Chuck