Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Handeling ?parameters Post Reply Post New Topic
Author Message
JagannathaS
Newbie
Newbie
Avatar

Joined: 02 Jun 2011
Location: New Zealand
Online Status: Offline
Posts: 1
Quote JagannathaS Replybullet Topic: Handeling ?parameters
    Posted: 02 Jun 2011 at 11:55am
Helo Newbie here ;-)
 
I have a large lump on my head from banging it repeatedly on the desk from frustration!!!!!
 
I hope I get get some relife here.....
 
I am trying to handle a ? variable input to present 'All Channels' if the % is selected from the drop down box.
 
I am using Crystal 10.
 
I have three parameters two fro dates and one of string, the string can be channels names or to assist in getting mutiple channels returned allow the users to select "%", what I would like to do is display "All Channels" when this is selected, I have tried all manner of formulae but none have been successful.
 
The parameter name is {?Channel}
 
I have tried so many permutations I feel embarassed at offering a code solution here.
 
Dead
 
 
IP IP Logged
Dewald
Groupie
Groupie
Avatar

Joined: 02 Jun 2011
Location: South Africa
Online Status: Offline
Posts: 47
Quote Dewald Replybullet Posted: 02 Jun 2011 at 8:00pm
First remove the {?Channel} from your selection criteria.
next add this to your selection formula.
 
And ({TableName.Channel} = {?Channel} or {?Channel} = "%" ) 
 
This should do the trick.
 
Dewald Botha
http://www.ITClarity.co.za
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.031 seconds.