Skip to Content
0

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

Sep 25, 2017 at 07:58 PM

24

avatar image
Former Member

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Ian Waterman Sep 26, 2017 at 11:30 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Abhilash Kumar
Sep 27, 2017 at 08:58 AM
0

Hi Deborah,

Have you tried this formula:

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

-Abhilash

Share
10 |10000 characters needed characters left characters exceeded