Main report value<-pass/return->subReport values (ActiveX Designer Component 6.0) 
Author Message
 Main report value<-pass/return->subReport values (ActiveX Designer Component 6.0)

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



Fri, 13 Jul 2001 03:00:00 GMT  
 Main report value<-pass/return->subReport values (ActiveX Designer Component 6.0)
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



Fri, 13 Jul 2001 03:00:00 GMT  
 Main report value<-pass/return->subReport values (ActiveX Designer Component 6.0)
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.



Sun, 15 Jul 2001 03:00:00 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. How to pass value from the subreport to main report

2. Pass value field subreport to main report

3. Passing values from a subreport to the main report

4. Passing values from subreport to main report

5. Passing values from the sub report, onto the main report

6. Linking subreport to main report using multiple-value or range parameters

7. How to pass a value from EXE -->IE50 container -->ActiveX Document

8. How to pass a value from EXE -->IE50 container -->ActiveX Document

9. <<<<<<<<ComboBox>>>>>>>>>>>>

10. Dynamic <img src> From Passed Value

11. Pass Sub-Report value to Main

12. <<<<Changing Value to CURRENCY>>>>>

 

 
Powered by phpBB® Forum Software