how to import data from main report to sub report

P

Pun

hi,
I am trying to inport a total sum from the main report to a sub report
for a calculation where i have to divide a number by that total to get the
percentage. Could you please tell me if there is a method to import that
total from the main report to sub report and also if there is a direct way to
calculate percentage.

Thanks!
 
A

Allen Browne

If you have a text box named (say) Text0 on the main report, you can put a
text box into your subreport, and set its ControlSource property to:
=[Report].[Parent]![Text0]
 
Top