hi,

I am currently working on a complicate report with about 6 sub report using
Seagate Crystal ActiveX Designer component 6.0 (free download from Seagate).

Here is situation:
I use ttx to bind data source later for all 7 reports(1 main and 6 sub
report). then I link them,
It works perfect,

but I need pass a value (commission rate) to 4 sub reports and
the sub reports will calculate the sub total for each sub report, and
then return the SubTotal values from sub report back to main report
then in the main report , add those sub report sub total (6 subtotal), come
out a grand total.

my question is:
a) how can I pass a value(commission rate) to those 4 sub report?
b) how can I return a value(which is sub total) from sub report to main
report and adds them up?

Great appreciate your help!

Robert Choi

hi,

I am currently working on a complicate report with about 6 sub report using
Seagate Crystal ActiveX Designer component 6.0 (free download from Seagate).

Here is situation:
I use ttx to bind data source later for all 7 reports(1 main and 6 sub
report). then I link them,
It works perfect,

but I need pass a value (commission rate) to 4 sub reports and
the sub reports will calculate the sub total for each sub report, and
then return the SubTotal values from sub report back to main report
then in the main report , add those sub report sub total (6 subtotal), come
out a grand total.

my question is:
a) how can I pass a value(commission rate) to those 4 sub report?
b) how can I return a value(which is sub total) from sub report to main
report and adds them up?

Great appreciate your help!

Robert Choi

I haven't used the ActiveXDesigner but here is how to do it in Native
Crystal and I assume that the ActiveXDesigner is similar.

First in the main report create a variable in a formula

StoreNumberVar("CommissionValue", 0)

In the subreport  in a formula
StoreNumberVar("CommissionValue", Numeric value)

Now retreive that value from the main report with

FetchNumberVar("CommissionValue")

Look up StoreNumberVar and FetchNumberVar in help.

If you are passing a field value (may also be true for calculated values I
just haven't done that yet) while editing the main report select from the
main menu Edit/Subreport links and you will be able to pass the field values
directly to the subreport. Crystal assume that you will want this in the
selection formula of the subreport so if you don't you will need to edit the
subreports record selection criteria.