Print Page | Close Window

Parameter as Array of user added values

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Tips and Tricks
Forum Discription: Have you learned some great tricks to share with the group? Post them here!
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=9547
Printed Date: 28 Apr 2024 at 4:43pm


Topic: Parameter as Array of user added values
Posted By: AlikY
Subject: Parameter as Array of user added values
Date Posted: 30 Mar 2010 at 8:06am
Hi!
I am using Crystal XI with SQL server.
I need the report witch will show Client ID and Client info from the Client.db table and the registration date witch aren't store anywhere.
Therefore, the parameter needs to be a combination of Client ID and the Date user will just type:
"Enter Client ID & Registration date in following format: 000000 - mm/dd/yyyy"
Record selection is: totext({Client.ID}) in (totext(Val({?Client ID & Registration date})))
Registration Date formula: Right({?Client ID & Registration date},10)
All this work very nice when we need show only one Client info with the Date.
How should I change the record Selection and the Formula to let user add multiple Clients.
Thanks a lot at advance.


Replies:
Posted By: lockwelle
Date Posted: 15 Apr 2010 at 3:21am
I don't know that you can.  You would have to have a multiple selection parameter, and I'm pretty sure that those come bound tables.
 
what might be simpler is to have the user enter all the information as a comma delimited string, and then in the record selection split the string into an array and proceed from there.
 
HTH


Print Page | Close Window