Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Data Connectivity
Message Icon Topic: Multiple Numbers as String Selectrion? 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: Multiple Numbers as String Selectrion?
    Posted: 17 Feb 2016 at 8:27am
Trying to create a user prompt for ClubNumbers but because it's numeric you can only enter one at a time.

I tried this with a parameter field set as String:

ToText({v060ClubOfficersClubAddress.ClubMbrNo},0,"") IN {?ClubMbrNo}


It does not work.

Thoughts/suggestions?
____________________
Thank you very much!
IP IP Logged
kevlray
Admin Group
Admin Group
Avatar

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Quote kevlray Replybullet Posted: 18 Feb 2016 at 4:25am
So what does not work?  Did you set your parameter to allow multiple entries?
IP IP Logged
techsupport
Groupie
Groupie


Joined: 03 Jun 2014
Location: United States
Online Status: Offline
Posts: 41
Quote techsupport Replybullet Posted: 18 Feb 2016 at 6:46am
Yes and when attempting enter a few club numbers, it just produces no results and the numbers being entered do exist.

Without the parameter, you can go into the Report Select Expert and select the ClubNo field then do a IN as the type and from there add the ClubNo.
However we are trying to avoid the end-user from going there to do that and prefer user-prompts.
____________________
Thank you very much!
IP IP Logged
kevlray
Admin Group
Admin Group
Avatar

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Quote kevlray Replybullet Posted: 18 Feb 2016 at 8:00am
Have you looked to see that the formula
ToText({v060ClubOfficersClubAddress.ClubMbrNo},0,""

is producing result you are expecting. I would think it should work.
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.016 seconds.