Group Header

[Former Member]

Hi All,

I have a report having group on tender type and in group header i kept summary fields.I checked repeat group header on each page.

My tender type values are like this.

cash   12
debitcard  45
creditcard  34
foreign currency 56

Some times if the tender names are is coming in end of page and it is repeating againg in starting of next page.
So the group footer value is again adding the gh tender values.I don't want the tender types repeat again in next page.
Please suggest

[abhilash_kumar · Accepted solution]

Hi Divya,

Do you add the Group Header values in the Group Footer or you just display the summarized value in the Group Footer?

Could you paste the summary formula?

-Abhilash

[Former Member · Accepted solution]

Hi Abhilash,

I placed summary values in group footer of employee name.

Formula for tendertype value in Group header  (@Net)

whileprintingrecords;
shared numbervar FC;
numbervar grand_tot;

numbervar sub_tot;

if {Join.tender_type_id}=1 then
(
     sub_tot := sub_tot + (sum({Join.net},{Join.tender_type_id})- FC);
grand_tot := grand_tot + sub_tot;
    
     (sum({Join.net},{Join.tender_type_id})- FC);
)
else
(
     sub_tot := sub_tot + sum({Join.net},{Join.tender_type_id});
grand_tot := grand_tot + sub_tot;
   
     sum({Join.net},{Join.tender_type_id});
)

Formula for sumarized value in employeename group footer a:  ( formula name @totalNet)

whileprintingrecords;

numbervar sub_tot;

numbervar g_total;

g_total := g_total + sub_tot;

sub_tot;

Reset variables i kept in employee name group footer b:

Reset var1:  (@reset)

numbervar sub_tot := 0;

Reset var2 :   (@reset1)

whileprintingrecords;

numbervar sub_tot := 0;

shared numbervar FC := 0;

whileprintingrecords;

[abhilash_kumar · Accepted solution]

Modify the @Net formula on the Group Header to:

whileprintingrecords;
shared numbervar FC;
numbervar grand_tot;

numbervar sub_tot;

if {Join.tender_type_id}=1 then
(

     if Not(InRepeatedGroupHeader) then

     (
          sub_tot := sub_tot + (sum({Join.net},{Join.tender_type_id})- FC);
          grand_tot := grand_tot + sub_tot;    
          (sum({Join.net},{Join.tender_type_id})- FC);

     )
)
else
(

     if Not(InRepeatedGroupHeader) then

     (
          sub_tot := sub_tot + sum({Join.net},{Join.tender_type_id});
          grand_tot := grand_tot + sub_tot;   
          sum({Join.net},{Join.tender_type_id});

     )
)

Let me know how this goes.

-Abhilash

[Former Member · Accepted solution]

Hi Abhilash,

I modified the @Net formula as you said but now it is showing tendertype names as it is in next page.But the value are becoming zero.But i don't want show those tender type names and values in next page.(if it shows end of previous page).

In 1st attachment bottom of page there is credit card tender with value 322.

In 2nd attachment same credit card tender is repeating with value 0.

[abhilash_kumar · Accepted solution]

You can suppress the values and names using this conditional suppression logic:

InRepeatedGroupHeader

To apply this formula, right click the field > select Format Field > Common tab > click the formula button beside 'Suppress'

P.S: If you wish to suppress the whole section, use the same conditional suppression logic on the Suppress formula for the section.

-Abhilash

[Former Member · Accepted solution]

Hi Abhilash,

I need to apply the suprression logic for section after modifieng the @net as you suggested above or without modifieng the @net .

Please suggest.

[abhilash_kumar · Accepted solution]

If you don't want the values to be added again when the Group Header repeats then you need to modify the @net formula.

If you don't wish to 'display' the same values when the header is repeated then you need to apply the suppression logic to the section or to the field depending on whether you wish to suppress the whole section or just some fields in that section.

-Abhilash

[Former Member · Accepted solution]

Hi Abhialsh,

i don't want show the repeated tender names and values in next page and i don't want to add.

So now i need to modify the @net formula as above and apply the suppression logic for the section?

Please suggest.

[abhilash_kumar · Accepted solution]

Yes you need to modify the formula and also apply suppression logic for the section.

-Abhilash

[Former Member · Accepted solution]

Thank you Abhilash