Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: group Post Reply Post New Topic
Author Message
zraja
Newbie
Newbie


Joined: 21 Feb 2014
Location: United States
Online Status: Offline
Posts: 3
Quote zraja Replybullet 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.

Current Scenario:
GH:952(Parent Part)
Detail 1234 (Child Parts)   
          2345 (Child Parts)
          3456 (Child Parts)
          4567 (Child Parts)
GH:872 (Parent Part)    
Detail    5678 (Child Part)
          6789 (Child Part)
          7890 (Child Parts)
          1234 (Child Parts)   

Proposed Solution:
GH#Custom-Name
          1234
GH:952(Parent Part)
          2345 (Child Parts)
          3456 (Child Parts)
          4567 (Child Parts)
GH:872 (Parent Part)    
          2345 (Child Part)
          6789 (Child Part)
          7890 (Child Parts)




Edited by zraja - 21 Feb 2014 at 8:54am
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet 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
IP IP Logged
zraja
Newbie
Newbie


Joined: 21 Feb 2014
Location: United States
Online Status: Offline
Posts: 3
Quote zraja Replybullet Posted: 21 Feb 2014 at 9:45am
how can I publish the suppressed ones into another group on top?
IP IP Logged
zraja
Newbie
Newbie


Joined: 21 Feb 2014
Location: United States
Online Status: Offline
Posts: 3
Quote zraja Replybullet 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.

Current Scenario:
GH:952(Parent Part)
Detail 1234 (Child Parts)      
          3456 (Child Parts)
          4567 (Child Parts)
          2345 (Child Parts)

GH:872 (Parent Part)     
Detail 5678 (Child Part)
          6789 (Child Part)
          7890 (Child Parts)
          1234 (Child Parts)
GH:850 (Parent Part)     
Detail 5432 (Child Part)
          9876 (Child Part)
          0987 (Child Parts)
         1234 (Child Parts)      
         2345 (Child Parts)


Proposed Solution:
GH#Custom-Name
          1234
GH:952(Parent Part)
Detail 2345 (Child Parts)
          3456 (Child Parts)
          4567 (Child Parts)
GH:872 (Parent Part)     
Detail 5678 (Child Part)
          6789 (Child Part)
          7890 (Child Parts)
GH:850 (Parent Part)
Detail 2345 (Child Parts)     
          5432 (Child Part)
          9876 (Child Part)
          0987 (Child Parts)
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
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



This page was generated in 0.031 seconds.