Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Beginner: Show certain details on command? Post Reply Post New Topic
Author Message
Stedman
Newbie
Newbie


Joined: 29 Oct 2010
Online Status: Offline
Posts: 4
Quote Stedman Replybullet Topic: Beginner: Show certain details on command?
    Posted: 01 Nov 2010 at 3:42am
Hello, I am new to CR and building my first report.  I am just wondering if what I want to do is possible, and if so, what would be the best way to go about it.  Here is what I am doing.
 
My report is a listing of purchase orders.  The fields of the report are;
 
purchase order #
amount of purchase order 
purchase order amount paid 
 
These purchase orders also have a 'Description' field which is very long and therefore not in my report.  But, this field is very helpful in identifying the purchase order for users. Is there a way I can make it so if a user clicks on the 'Purchase Order #' field they can view the description somewhow?  Or, is there some other way to make the 'Description' field available on-demand?
 
Thanks.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 01 Nov 2010 at 3:50am

you can do this as drilldown on a group or as a sub report

IP IP Logged
Stedman
Newbie
Newbie


Joined: 29 Oct 2010
Online Status: Offline
Posts: 4
Quote Stedman Replybullet Posted: 01 Nov 2010 at 4:21am
On the drill-down I tried putting the 'Description' field in Detailsb, but if I try to hide details b, it hides details a as well.
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 01 Nov 2010 at 4:28am

you can conditionally suppress using drilldowngrouplevel

details a as drilldowngrouplevel>2 (assuming you never want it suppressed
details b as drilldowngrouplevel=0
 
 
IP IP Logged
Stedman
Newbie
Newbie


Joined: 29 Oct 2010
Online Status: Offline
Posts: 4
Quote Stedman Replybullet Posted: 01 Nov 2010 at 4:51am
Thanks, I'll try that.
IP IP Logged
Stedman
Newbie
Newbie


Joined: 29 Oct 2010
Online Status: Offline
Posts: 4
Quote Stedman Replybullet Posted: 01 Nov 2010 at 5:33am
Took some playing around, but I got it figured out with your suggestion.  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.