Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Display prompt description Post Reply Post New Topic
Author Message
Dura60
Newbie
Newbie
Avatar

Joined: 14 Oct 2009
Location: Canada
Online Status: Offline
Posts: 2
Quote Dura60 Replybullet Topic: Display prompt description
    Posted: 14 Oct 2009 at 6:31am
I'm having troubles displaying a field when the report comes back with no matches.
 
If there are no matches i can't get the whse number and description to print in my headings when using database fields.
 
I tried to create a prompt to select the whse wanted and can now display the whse number, but can't figure out how to display the prompt description.
 
Any suggestions on how i can get headings to appear on a report that returns no matches, even if its just the prompt description.
 
 
Thanks
 
 
IP IP Logged
Dura60
Newbie
Newbie
Avatar

Joined: 14 Oct 2009
Location: Canada
Online Status: Offline
Posts: 2
Quote Dura60 Replybullet Posted: 14 Oct 2009 at 9:59am
i should clarify.
 
Here is my select expert
whse_id = (can pick 1 of 9 from dropdown menu) and onhand_qty > 0
 
Report heading
ONHAND STOCK : {WHSE_ID} - {WHSE_SHORT_DESC}
 
this works fine if there is stock. If there is no stock then both {whse_id} and {whse_short_description} are blank.
 
So i switched to using a prompt and my select expert looks like
whse_id = {?whse_id} and onhand_qty > 0
 
Report heading
ONHAND STOCK : {?WHSE_ID} - {how do i get the prompt descrition to print}
 
 
 
 
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.047 seconds.