Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Parameter with several choices does not work Post Reply Post New Topic
<< Prev Page  of 2
Author Message
Piinutti
Newbie
Newbie


Joined: 12 Mar 2012
Location: Finland
Online Status: Offline
Posts: 17
Quote Piinutti Replybullet Posted: 15 Mar 2012 at 2:39am
I have tried several tricks to get this parameter to work. I tried to make the array for this and now I have this error message when I try to use the report.

Have anyone a way how to make a array from already existing values? (These come from already existing table and field). I think that is the problem now. I don't have any tricks in my sleeve anymore..



IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 15 Mar 2012 at 4:00am

creating a formula field has NO impact on record selection (unless it is enforcing a join that was not already enforced).

As I stated earlier you have to write a select statement (a boolean formula) inside the select expert to do this.
 
putting
table.field = {?parameter}
into the select expert will limit the rows to whenever this evaluates to TRUE
this will only evalaute to true when the table.field (your database field) has as string (text) value = to any string value (1,2,3,4 or 8) entered into your parameter at run time.


Edited by DBlank - 15 Mar 2012 at 5:29am
IP IP Logged
kostya1122
Senior Member
Senior Member
Avatar

Joined: 13 Jun 2011
Online Status: Offline
Posts: 475
Quote kostya1122 Replybullet Posted: 15 Mar 2012 at 5:27am
i think that maybe your parameter is not set up correctly
inside your parameter try replacing your 1-8 values that you have in 
Value column with the values that you have in your
description column.
IP IP Logged
Piinutti
Newbie
Newbie


Joined: 12 Mar 2012
Location: Finland
Online Status: Offline
Posts: 17
Quote Piinutti Replybullet Posted: 16 Mar 2012 at 1:48am
Thank you guys for the help. I have now managed to get the parameter work properly. It is now working just as I wanted.
IP IP Logged
<< Prev Page  of 2
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.016 seconds.