Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Selecting Records with a String parameter containing a list of ID's

Status
Not open for further replies.

DaddyChris

Programmer
Feb 12, 2005
4
US
I have a report that looks at a table called Containers.

I would like to pass in a parameter string containing all the ID's of the containers that I want to work with.

1) After getting the ID's from the string using split(), how can I retrieve the records of those ID's?

2) Once I have the records, I need to group them by the depots that they will be going to. Do you have any tips on doing this?
 
A record selection formula of:
{MyField} in ["stringa","stringb",...]

Is how to work with only those records in the list. Is this what you are trying to do?

Why are you passing the parameter to crystal instead of having a user interface?


Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top