Skip to Content
avatar image
Former Member

Two Group Footers with duplicate rows of data in group 1 and group 2...

My report shows

Group Footer #1a

Formula1 with data "IEL1234"
Group Footer #1b

Formula2 with data "IEL1234"

On the selection expert Group Footer #1b I have checked the supress box when:

(isnull({CSM_UNDERLYING_SECURITY.UNDERLY_SEC_ID})or ({@Formula2}=previous({@Formula1})))

The isnull suppression works but not the "duplicate row a=previous" statement. I still see duplicate row data in group footer 1a and 1b.

Urgent daily report....thanks for your support.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Sep 26, 2017 at 11:30 AM

    You need to compare max values as you are comparing at group level, but I don't think you can use max summaries with Previous.

    Place the fields @Formula2}, {@Formula1} onto report in group sections and see what values are there.

    You might need to capture values using Variables and then use these to suppress sections.

    Ian

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 27, 2017 at 08:58 AM

    Hi Deborah,

    Have you tried this formula:

    isnull({CSM_UNDERLYING_SECURITY.UNDERLY_SEC_ID}) or ({@Formula2} = {@Formula1})

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded