I have a report with 2 sub report that has a db field link.

The run time of the report is not at acceptable. The report performance will be improved if one of sub report is removed. But my problem is that I don't know how to or whether it's possible to create a formula to use report fields from main and sub report.

i.e.  main.total/ (subReport1.Sum) + main.total1.

I cannot see sub report 1 field when I am in main report.

I wonder if it's doable to create a formula as I wanted. Any help is greatly appreciated.

Can you give me details on assigning results in formula to a shared variable?