Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Parameters Post Reply Post New Topic
Author Message
thummel1
Senior Member
Senior Member
Avatar

Joined: 27 Apr 2012
Location: United States
Online Status: Offline
Posts: 140
Quote thummel1 Replybullet Topic: Parameters
    Posted: 15 Jul 2013 at 3:31am
Hi, I am using CR08. I set up a parameter that allows the user to select static values (I've tried dynnamic too that reside in a data field of a table. One of the data elements in the data field is blank. So the list they are selecting from looks something like this:
 
<<This is an empty row choice>>
SMG
THF
SUG
 
When I request to bring all values into the paramter and run the report, the empty field does not transfer over to the right hand side when I select all. There are records that have empty fields that need to be included, or at least, the user needs the option to include them. 
 
How can I get my parameter to include the records where the data field is empty? If I need to explain this better I'll be happy to do that.
"Press any key to continue. Where's the 'Any' Key?" ~Homer Simpson
IP IP Logged
Sastry
Moderator
Moderator
Avatar

Joined: 16 Jul 2012
Online Status: Offline
Posts: 537
Quote Sastry Replybullet Posted: 15 Jul 2013 at 3:37am
Hi
 
Even though it shows a blank row in your parameter list of values, crystal can't handle NULL values.
 
You can do the following to retive all the values into your report.
 
a. Modify your parameter as Optional Parameter.  i.e enable Optional as true
 
b.  In record selection use the following formula to extract values.
 
If hasvalue({?Parameter}) then true
else
 
{?Parameter} = {Database field}
 
If user press enter insted of selecting values from parameter then it will display all values.  If he enters any value it will filter those values and show the data.
 
 
Thanks,
Sastry
IP IP Logged
thummel1
Senior Member
Senior Member
Avatar

Joined: 27 Apr 2012
Location: United States
Online Status: Offline
Posts: 140
Quote thummel1 Replybullet Posted: 15 Jul 2013 at 3:48am
Thank you! This worked perfectly!
"Press any key to continue. Where's the 'Any' Key?" ~Homer Simpson
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.