Workaround for SQL Command Parameter with Dynamic List of values

[PNC]

Hi all,

I know this has been discussed multiple times on this forum, but I would like to know if anyone came up with a workaround since the last post on this. How can I have a parameter with a dynamic list of values on the SQL command.

I'm using CRXI, and I don't want to put the parameter in the select expert, because it means I would have to download all the records then filter them, and that would be bad on the performance of the report.

Any new ideas? Is there a 3rd party tool that I can use? I have heard about using a text file, but I don't know how to implement this solution.

Thanks.

 

[PNC]

I don't like to do this but...BUMP!!!

 

[PNC]

OK, here's what I did, instead of using a command query, I linked the tables, I added record selection parameters and I converted all of my formulas into SQL expressions, in order for the query to be performed on the server.