Surpress a group on condition or (Some times to show some other times Hide)

[Former Member]

Hi All,

I have to supress a group on some condition and some time it should show, please see the below example report layout.

Group 1: 12/10/2007
Group 2: Anchor (ANC)
Detail: BERTOLACCINI, SILVIA 
Detail: BERTOLACCINI, SILVIA
Detail: BONNER, MICHELLE
Detail: COHN, LINDA
Sub Total: 4

Group 1: 12/10/2007
Group 2: Associate Director (AD)
Detail: AYALA, ALEX
Detail: DEANES, ALISA
Detail: FLOCKHART, KALYN
Detail: LAGANO, SCOTT
Detail: PETRIW, DAN
Sub Total: 5

Grand Total: 9

Currently I am displaying like above; after evey sub total I need a line of gap, but at the end of the Grand Total that is between Sub Total and Grand Total there should not be a line of gap. That is

Group 1: 12/10/2007
Group 2: Associate Director (AD)
Detail: AYALA, ALEX
Detail: DEANES, ALISA
Detail: FLOCKHART, KALYN
Detail: LAGANO, SCOTT
Detail: PETRIW, DAN
Sub Total: 5
Grand Total: 9

How do I supress the line of gap between Sub Total and Grand Total at the end for every Group total for that particular date.

Any help is appreciated. Thanks in advance.

Ashok

[Former Member]

Hi Ashok

Sub total is calculated for the group footer and the grand total is calculated for all the records hence grand total is ideally placed at the report footer.

The workaround would be to create a formula field to calculate the summary of the field instead of inserting a summary field for grand total.

You can place this formula field in the group footer also.

Hope this helps!!!

Regards

Sourashree

[Former Member]

Hi Sourashree,

Its not a sum I have to do count.

And how do I write the formula field to calculate the summary of the field instead of inserting a summary field for grand total? How do I acheive this any Idea?

Thanks,

Ashok

[Former Member]

Hi Ashok

Do the below steps:

1. Open the field explorer

2. Right click on formula field and click on new.

3. Put a name for the formula field.

4. Put the below formula

Count(fieldname)

5. Click on X-2 to compile.

6. Click on save and close.

Now place this formula field in the group footer or where you want.

Hope this helps!!!

Regards

Sourashree

[Former Member]

Hi Sourashree,

The filed Count(fieldname) field is not a numeric field its string. Clearly I wanted to count the persons how many on those days.

If any other workaround please let me know.

Thanks,

Ashok

[Former Member]

Hi All,

I have solved it myself.

I have created a runnung total.

In the group (What I supposed to supress based on condition) section expert and I wrote a condition formula in the supress X-1 button like below.

Count ({DBP_BOPS_HLDYS_DAYS_WRKD.PRSN_NM}, {@@GWorkDateGrouping}, "daily") = {##RecordCount}

It may be helpfull for someone.

Thanks.

Ashok