Print Page | Close Window

Multiple Numbers as String Selectrion?

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=21887
Printed Date: 28 Apr 2024 at 6:55am


Topic: Multiple Numbers as String Selectrion?
Posted By: techsupport
Subject: Multiple Numbers as String Selectrion?
Date 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!


Replies:
Posted By: kevlray
Date Posted: 18 Feb 2016 at 4:25am
So what does not work?  Did you set your parameter to allow multiple entries?

Posted By: techsupport
Date 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!

Posted By: kevlray
Date 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.


Print Page | Close Window