Passing value from Sub-Report to Main-Report

[nicola]

Can anyone please help me...
Did anyone know how to pass a sum value (or any value) from Sub-Report to Main-Report?
I mean pass it to a formular or parameter, not just view it on Main-Report.

Please and Thank you.

I am using Crystal Report 8.0 and Ms Access Database.
Report Connection : ODBC Connection.

[brucevde]

You need to use a Shared variable.

In the subreport create a formula that contains/calculates the value you want to pass across. Something like

Shared currencyVar TotalAmount := Sum ({[Order Details].Amount});

In the main report create a formula that uses this shared variable. Something like

Shared currencyVar TotalAmount;

If TotalAmount > 1000 then 
   TotalAmount * .1
Else 
   TotalAmount * .05

Both formulas must use the exact same variable declaration. See the help file for more info on creating variables.

[nicola]

Thanks for your reply brucevde. These code really help me a lot and I think this is very cool. (about the Shared Var)

[Manticore]

Hi.

Sorry about my lack of knowledge, but how do you declare the variable? I don't really use VBA, so where do you do that? It keeps giving me this error:

Compile error:

Expected: line number or label or statement or end of statement

=======================

Here's my code (I just pasted yours above Option Compare Database)

Shared currencyVar TotalAmount := Sum ({[Order Details].Amount});

Option Compare Database

Thanks

[brucevde]

The code shown is used in Crystal Reports and has nothing to do with VBA.

[Manticore]

Sorry