summarizing unbound subreport fields

Hello,
I have a subreport that displays 0-to-many rows.
I have an unbound field (UnBound1) with a formula that calculates for each row.
Then I have a field in the subreport footer (UnBound2) that sums this UnBound1 field.
My question is - how can I refer to this UnBound2 field from my main report
I need to summarize all my subreport data on my main report.
Thanks in advance!
Amber



Answer this question

summarizing unbound subreport fields

  • Zhou Justin

    Hello Amber,

    You could use a formula fields and store the value to be passed using Shared Variables.

    You would need a formula in each the main and the subreport that referenced the same variable name...from the help file (Crystal syntax):

    Shared variables use the same memory block to store the value of a variable throughout the main report and all of its subreports. Thus shared variables are even more general than global variables. To use a shared variable, declare it in a formula in the main report as in the following example:

    Shared NumberVar x := 1000;

    and declare it in a formula in the subreport as in the following example:

    Shared NumberVar x;

    In order to use shared variables, the variable must be declared and assigned a value before it can be passed between the main report and the subreport.


    Keith - Business Objects



  • summarizing unbound subreport fields