Multiple Values Parameter with CR7

[ksaben]

Hi all,

I've just started working with Crystal Reports. I've successfully run a SQL Server 7 view from ASP with the Java and ActiveX viewers. But here comes the tricky part.

I need to pass multiple integer values to a parameter. I can pass one value without a problem, but multiple values seems to be an issue. According to the manual and Crystal Reports help, I could pass as a string, but this would provide inaccurate data (i.e. a list of 3, 10, 27 would give me records that match '1', '2', '7' etc.) It seems CR8 allows the command 'Param1.EnableMultipleValues = 1', but this doesn't seem to work in 7. Is there something obvious I'm missing? Does anyone have an alternate solution to doing filtering on the fly?

Thanks for any help.

 

[dcm]

madstork: If you pass your values as a comma delimited list of fixed width values e.g. "01,03,10,27" then you could 'break up' the resultant string into its constituent parts and convert each part into a numeric using the Val() function before testing. Otherwise I'm afraid it's either loop through in your code to deliver multiple parameters each with a single value or upgrade ;-)) David C. Monks
david.monks@chase-international.com

http://www.chase-international.com

Accredited Crystal Decisions Enterprise Partner