Input from file

[rereis]

Hello all

I need to do a "is one of" comparison in the select expert but I am dealing with 12000 records.

I am aware of
{ORG.NAME} in ["here is my string","here is my 2string" ]

but with my large list this is a lot of work, plus the array limit is 1000 items.

Is there a way to achieve the same but input the list of value from a external file?

something like:
{ORG.NAME} in c:\myfile.txt

Thanks

 

[Madawc]

I'm not clear what you're after. A crosstab in the report footer or header would give you a list of all the different text strings and could also count occurences. Or you could group by text string, assuming there is nothing else you need to group by.

If it is a particular value, you could do that with a running total using a formula. If you're not already familiar with Crystal's automated totals, see FAQ767-6524.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[lbass]

You should probably identify what these organizations have in common or what organizations you are excluding and use that in your record selection instead of the list of names. If you mean to access all organizations, then of course you would not use any selection criteria for organizations.

One way of generating the list would be to use a separate Crystal Report where you added the following to a text box in the detail section:

"{ORGNAME}",

Then export the report to text and then you can copy the results into the record selection area, removing the final comma, and placing the whole in square brackets.

-LB