Print Page | Close Window

group

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=20506
Printed Date: 20 May 2024 at 9:16am


Topic: group
Posted By: zraja
Subject: group
Date 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)




Replies:
Posted By: DBlank
Date 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

Posted By: zraja
Date Posted: 21 Feb 2014 at 9:45am
how can I publish the suppressed ones into another group on top?

Posted By: zraja
Date 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)


Print Page | Close Window