Display Sum(xy) in a DataBand

[scotty]

How can I display the sum of a column (calculated in a GroupFooter of a dataBand) in a DataBand (here DataBand1)

HeaderBand1
Column1 Column2

DataBand1
Value1 Value2 Sum(xy)

GroupHeader1

DataBand2
Value3 Value4 ...

GroupFooter1
Sum: Sum(xy)

[Vital]

I need more information. On one DataBand1 report engine can show more then one group.
For example on one DataBand1 we have 3 groups. Which totals from 3 we need to display
in DataBand1? Can you explain?

[MARIMUTHU K]

HI hi hi ,

My Need Same Problem,

I have worked CR 9.0 and solved that Problem.

That means 3rd Column Value Reference to 2nd COlumn Value.

Example

Col1 col2 col3

1 10 64
2 20
3 34
-----------
Sum 64


Col3 Reference to Col2.

Is Possible ?


Regards,
KMarimuthu.

[scotty]

Hi Vital

In my Report i have 2 different datasources (ProjectStep and ProjectActivity).
In the first DataBand in each row i want to display infos about one ProjectStep and the Sum of performed hours for the ProjectStep (calculated as Sum of performed Hours from the corresponding ProjectActivities from the second DataBand in the GroupFooter)

HeaderBand1
ID Caption ... Sum of performed Hours

DataBand1
[ProjectStep.ID] [ProjectStep.Caption] ... [here i want to display the Sum from GroupFooter1]


GroupHeader1

DataBand2
[ProjectActivity.ID] .... [ProjectActivity.Hours]

GroupFooter1
[Sum(ProjectActivity.Hours)] --> the calculated Sum should be displayed in DataBand1

[Vital]

To scotty:

Write on DataBand1:

Sum(DataBand2, xy)

To KMarimuthu:

Sum(col2)

Thanks.

[MARIMUTHU K]

HI hi hi


Thanks .



Regards,
KMarimuthu.