melaniecarr23
Programmer
Hopefully someone other than myself finds this useful:
I was creating a report with several sub-reports on it. Of course you want some of the values from the subreport to show on the main report. Here is how you do it:
Create a control on your main report, and assign it this value:
=ReportName.ControlType![ControlName]
example:
=dd_report.Report![2005overflow]
dd_report is the name of my subreport
Report is where my control is located (versus a form)
the name of my control is 2005overflow
NOTE: if you are using the expression builder to do this, you can't just pick the subreport itself, you have to go in through the loaded reports, then the main report, then pick the subreport. I couldn't get it to work otherwise. If someone else can, wonderful - please post how so the wealth is spread.
Have a wonderful day!
I was creating a report with several sub-reports on it. Of course you want some of the values from the subreport to show on the main report. Here is how you do it:
Create a control on your main report, and assign it this value:
=ReportName.ControlType![ControlName]
example:
=dd_report.Report![2005overflow]
dd_report is the name of my subreport
Report is where my control is located (versus a form)
the name of my control is 2005overflow
NOTE: if you are using the expression builder to do this, you can't just pick the subreport itself, you have to go in through the loaded reports, then the main report, then pick the subreport. I couldn't get it to work otherwise. If someone else can, wonderful - please post how so the wealth is spread.
Have a wonderful day!
