GF2 total to be displayed on GH1 1

[thisisboni]

Hi:

I'm on CR 10 - need to display a group total in a header section - here is the report layout

GH1:
GH2:
D:
GF2: @totals_to_displayed
GF1:

@totals_to_displayed needs to be displayed on GH1
How can this be achieved -

Any help will be much appreciated !
Thanks

 

[hilfy]

Is there only one group 2 for every group 1, or does each group 1 have multiple group 2's? If there are multiple group 2's, how do you need to display the data?

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.

 

[thisisboni]

Hi:

Just saw your reply -

For each value in Group 1 there can be either one or two values in group 2.

so the total(s) calculated at group 2 Footer needs to be displayed on Group 1

e.g Group 1 has 2 values in Group 2 - Value_A, Value_B

in Group 1 (Header) I need to show
Value_A
Value_B

Tx

 

[lbass]

You could insert a crosstab in the Group #1 header and add the group #2 field as the row field, and use a maximum for the summary field. Then remove the grid and suppress the row label and total.

-LB

 

[lbass]

Sorry, I meant use the group#2 field as the row field, and add the value you are totalling as the summary field, using sum as the summary type.

-LB

 

[thisisboni]

here is what I did -

GH1a: SUM({item},GH2)
GH1b: SUM({item},GH1) - SUM({item}, GH2)
GH2:
D:
GF2:
GF1:

this did the trick !
I'll try out your solution -

Thanks