Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Drill Down past empty headers Post Reply Post New Topic
Author Message
carstowal
Groupie
Groupie


Joined: 31 Jul 2008
Online Status: Offline
Posts: 80
Quote carstowal Replybullet Topic: Drill Down past empty headers
    Posted: 28 Aug 2009 at 8:01am
using CR9

GroupHeader1 - visible
GroupHeader2 - visible
GroupHeader3 - hidden
GroupHeader4 - empty (no fields on printed report)
GroupHeader5 - empty (no fields on printed report)
Details - Hidden, also have conditional suppression
GroupFooter5 - empty (no fields on printed report)
GroupFooter4 - empty (no fields on printed report)
GroupFooter3 - empty (no fields on printed report)
GroupFooter2 - visible
GroupFooter1 - empty (no fields on printed report)

I need to have the Details HIDDEN but how can I get them to appear on a Drill Down?
When clicking on the GroupHeader2, GroupHeader3 appears, as GroupHeaders4&5 are empty, I can't Drill Down to the details.
How can I Drill Down, preferrably in one click from GroupHeader2?
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 28 Aug 2009 at 9:29am
Can you come up with a logic that works for condtionally suppression of the sections using drilldowngrouplevel and show all headers on drilldown as True.
How drilldowngrouplevel works...
upon report open it = 0
 first drilldown =1
etc.
 
Note it has nothing to do with Group level, just if you drilled down. Meaning if you have group1 and group2 visible upon report opening and the user drills directly into a group2 level it makes drilldowngrouplevel=1.
To visually understand this and test it out create a formula field as "testDDGL":
drilldowngrouplevel
Place it on a Report header (assuming and made it available on drilldowns) and you can see it change on drilldowns.
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.016 seconds.