I have a report that I need to execute based on a single customer number, several, or all. There are too many for a drop-down list. How can I set it up so that the user can enter a single number, multiple comma separated numbers, or have it run
for ALL customers (as default)?
I tried having a default value of *, and had my SQL condition set as "and ixCustomer in (@Customer)" but the customer# field is an int so that would not work. Suggestions?
View Complete Post