Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Header display persistance Post Reply Post New Topic
Author Message
attila
Newbie
Newbie


Joined: 29 Mar 2017
Location: France
Online Status: Offline
Posts: 1
Quote attila Replybullet Topic: Header display persistance
    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
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3701
Quote hilfy Replybullet 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
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.030 seconds.