Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: parameter field Post Reply Post New Topic
Author Message
jay52
Newbie
Newbie


Joined: 17 Jul 2009
Online Status: Offline
Posts: 9
Quote jay52 Replybullet Topic: parameter field
     Posted: 07 Feb 2011 at 4:52am
i want to add a parameter field to a crystal XI report. this field has thousands of possible values (it's like a record id number). So users will usually select to see all of them or type in just one value.... what is the best way to create a type in / all parameter field?
IP IP Logged
FrnhtGLI
Senior Member
Senior Member
Avatar

Joined: 22 May 2009
Online Status: Offline
Posts: 347
Quote FrnhtGLI Replybullet Posted: 07 Feb 2011 at 5:42am
This will be a two part process.
 
First Part
Create the parameter as a String Type and have the List of Values Static. Choose the field {table.recordid} as the Value Field and add a description if you please. Make sure Allow Custom Values is set to True.
 
Second Part
Go to Report -> Selection Formulas -> Record. and add the following code:
 
({?NewParameter}="ALL"
and
{table.recordid}={table.recordid})
 
or
 
({table.recordid}={?NewParameter})
 
Where {?NewParameter} is the name of the parameter field you created.
|< /\ '][' ( )
IP IP Logged
jay52
Newbie
Newbie


Joined: 17 Jul 2009
Online Status: Offline
Posts: 9
Quote jay52 Replybullet Posted: 07 Feb 2011 at 6:03am
thanks looks like that gave me what I was after.
IP IP Logged
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