Select Expert - select one of hundreds 2

[PrograMist]

Hello,

i need to select records from the database that would equal a number (close to a hundred) of userIDs. Is there any way to automate this selection process as opposed to typing these multiple userIDs in the select expert one by one (in the "one of" category)? Is it possible for Crystal Reports to read these userIDs from a text file, for example? if so, could you please let me know how this can be done?

Thank you in advance for your help,

PrograMist

 

[crystalreporting]

If you can compile the list of users using a tool that you can 'copy and paste' from, then you could edit the selection formula directly in Crystal (instead of the select expert) and paste the list in. You'll still have to do some manual editing either way.

Peter Shirley

http://www.linkcorp.com

 

[PrograMist]

I kind of expected that. Thank you, crystalreporting!

 

[GMcNamara]

I am not sure if this is what you want, but you can create a parameter and import a list of default parameter values. Select your parameter, click edit - set default values - import picklist. Then you will be prompted for the file that contains the default values. Hope this helps.

 

[PrograMist]

GMcNamara, thank you -- I will try this as well.

 

[lbass]

If any of these IDs are in sequence, you can save a lot of data entry time by clustering them. Instead of using the select expert, go to report->edit selection formula and enter something like:

{table.ID} in [1 to 6, 21 to 29, 33 to 36, 38, 41 to 53]//etc.

But a larger question is what do all of these hundred or so records have in common that leads you to want to select only them? The answer to this would probably be a better and simpler selection criterion, so it would be interesting to know...

-LB