Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: One Of Numeric Parameter? Post Reply Post New Topic
Author Message
techsupport
Groupie
Groupie


Joined: 03 Jun 2014
Location: United States
Online Status: Offline
Posts: 41
Quote techsupport Replybullet Topic: One Of Numeric Parameter?
    Posted: 13 Nov 2015 at 4:52am
I would prefer to have parameter prompts for the end-user rather than they having to go into the Report Select Expert.

However, I'm not sure how to do that for the One Of option?

The user would like to copy and paste a long list of member numbers versus selecting them one by one which is the case with the parameter prompt since that seems to only work for the Equal To and the parameter field is set for Multiple. you can't copy and paste the member numbers you have to enter each one at a time.

They want the ability to just simply copy and paste them.

ClubMbrNo IN [910, 945, 958] versus
ClubMbrNo = 910 then 945 then 958 <-- this takes too long.
____________________
Thank you very much!
IP IP Logged
techsupport
Groupie
Groupie


Joined: 03 Jun 2014
Location: United States
Online Status: Offline
Posts: 41
Quote techsupport Replybullet Posted: 30 Nov 2015 at 5:56am
I changed the Parameter Field to Type: String
then have this in Select Report Expert
ToText({v060ClubOfficersClubAddress.ClubMbrNo},0,"") IN {?ClubMbrNo}


It's not working, anyone have a solution for this?




Edited by techsupport - 30 Nov 2015 at 6:00am
____________________
Thank you very much!
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.