Tips and Tricks
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Tips and Tricks
Message Icon Topic: Optional detail Lines Post Reply Post New Topic
Author Message
The Ricker
Newbie
Newbie


Joined: 01 Feb 2010
Location: United States
Online Status: Offline
Posts: 3
Quote The Ricker Replybullet Topic: Optional detail Lines
    Posted: 01 Feb 2010 at 12:57pm
I am new to CR so be patient.  I want to print one detail line format from 5 or 6 different formats based on a user-selected report option input parameter.  When I create multiple sections and base their suppression or non-suppression on the selected parameter the detail that I want does print.  However, the space taken up by the suppressed lines does not disappear.  How do I eliminate all of the detail line space used by the suppressed optional detail line formats?
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 02 Feb 2010 at 8:22am
Are you conditionally suppressing the fields or the entire section (e.g. detail A, Detail B, etc.)?
IP IP Logged
The Ricker
Newbie
Newbie


Joined: 01 Feb 2010
Location: United States
Online Status: Offline
Posts: 3
Quote The Ricker Replybullet Posted: 02 Feb 2010 at 9:15am
I have tried it both ways using a conditional phrase like:
if {?Parameter Value:} = 'Basic' then false else true, where 'Basic' is one of the report options defining which detail line to print.  I also need to print different headings depending on the report option.  Unless I am wrong this does not seem to be something that is done with subreports.
 
It must be simple to do, so obviously I am doing something wrong.  This was trivial to do in FoxPro's report writer so I am really frustrated using CR.  Thanks much.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 02 Feb 2010 at 9:27am

OK, not sure exactly how you have this set up but here is a process.

Create 5 (or 6) distinct details sections
Create your formatting as needed per detail section.
Create your Paramter field with the 5 (or 6) different options.
Open the section expert.
Highlight Details A and click on the formula box next to the Suppress No drill down. Add your formula here as:
NOT ({?Parameter Value}="Basic")
//assuming details a is the "Basic" view.
Repeat for details section b but change the formula to
NOT ({?Parameter Value}="Advanced")
//assuming details b is the "advanced" view.
Repeat for all your detail sections.
 
IP IP Logged
The Ricker
Newbie
Newbie


Joined: 01 Feb 2010
Location: United States
Online Status: Offline
Posts: 3
Quote The Ricker Replybullet Posted: 02 Feb 2010 at 12:17pm
Everything now works as expected.  Thanks.
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.020 seconds.