Joined: 21 Feb 2014
Location: United States
Online Status: Offline
Posts: 3
Topic: group Posted: 21 Feb 2014 at 8:53am
Hi All,
I have a report with grouping.
see below example:child part 1234 is repeating under both groups and I am looking for a formula that will suppress child part if repeated under all groups and display once at the top of report.
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Posted: 21 Feb 2014 at 9:18am
shared variable fomrula to concatenate the child part string with some seperator then use that result to suppress the row using an instr() comparison of the row into the concatenated result
Joined: 21 Feb 2014
Location: United States
Online Status: Offline
Posts: 3
Posted: 21 Feb 2014 at 10:37am
Lets take the scenario with 3 groups to better understand.
Child part 1234 is present in all the groups so it is suppressed under respective groups but displayed on top where as child part 2345 is only present in 2 groups so its neither suppressed nor displayed on top.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum