Crystal Reports - SubReport

[Confucius]

Can you pass a variable from a SubReport back to a main report?

I have a report with tables with one to many relationship. Header table with many detail records. The subreport is currently calculating an amount on the many to one detail table and I would like to pass that figure back to the main report for further use.

Any help will be appreciated.

Thanks

[vbUserName]

It might be more comfortable using a formula

[Confucius]

Oops, I meant formula field instead of variable.

The problem is that my main report does not have access to the subreport's formulas that I can see nor vice versa.

[vbUserName]

Do you have to use a subreport?

[Confucius]

Unfortunately, yes.

The main report gathers info. from different tables, the subreport gathers the many to one counts and dollar values that I need to then use in my calculation for subtracting from the main reports findings.

Any ideas of other ways to handle this scenerio are welcomed.

[vbUserName]

You can have a Query or temporal table in your database that calculates the values and then get that values from the query or table to your report. That makes it easier, I think.