Header display persistance
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=22289
Printed Date: 28 Apr 2024 at 7:59am
Topic: Header display persistance
Posted By: attila
Subject: Header display persistance
Date Posted: 11 Apr 2017 at 6:02am
Hello 
I’m a beginner on Crystal Report and on this forum I didn’t see any welcome section so hello everybody I’m a not so young French guy working in Paris in BI. I began CR 2 months ago I have to maintain big dashboards 
The version is CR 2008 On a new dashboard, I have a display problem: I have a first group header which is displayed once on the page (H1) then a new group header (H2), then a last one (H3) with make a table with details (D) So the display on my page is : H1 H2 H3 + D1-D2-D3 H2 H3 + D1-D2-D3 H2 H3 + D1-D2-D3 H2 End of the page On many pages, I have a H2 without H3 and his details which is not “beautiful “ for users Do you have any idea how can I get rid of this ? A kind of rule to remove this display if there is no H3 + D1-D2-D3? Many thanks 
Francois ------------- Attila |
Replies:
Posted By: hilfy
Date Posted: 13 Apr 2017 at 6:23am
|
What determines whether there is H3 and details?
I would right-click on the gray area to the left of the H2 section and select "Section Expert". Then click on the formula button to the right of "Suppress" (DO NOT check the Suppress checkbox!) Finally, using a field from the details that will have data if the details exist for H3 and/or its details but won't have data (will be null) if they're not present, enter the following formula: IsNull({table.detail field}) This will suppress the H2 section if there's no detail data. -Dell ------------- Proviti, Data & Analytics Practice http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics |