Click to See Complete Forum and Search --> : passing multiple values in 1 parameter variable


technie
July 1st, 2006, 01:21 AM
hi,

i m unable to pass a string of values in vb6 to crystal report 8.5. using cr control (not cr viewer).

I have created a var in CR.rpt to accept multiple discrete values.
User is able to choose any number of records from the form and the values of the selected record ids are stored in values_str.

eg.
values_str = "'101', '102', 103'"

how to pass the values from values_str to CR such that the stored procedure will select the records based on the ids and the report will display correctly?

some sample codes will be very helpful. thanks!

pallavi.shinde
September 21st, 2006, 02:48 AM
click check box of "Allow multiple Values" while creating New Parameter in Options Tab.

blackbon
November 20th, 2006, 11:21 AM
Ok thats easy. Let's make thing a bit more complicated...

How to pas a multiple value parameter, which values are selected with SQL query, into a SQL command in Crystal Reports?

If you create new parameter inside of Modify Command Screen you cannot set multiple value flag.
If you crate a parameter outside of Modify Command Screen you cannot add it to the command:)

I hope I'm making it clear enough but if you would like to crack it and you'd like to know anything else just ask:)

I just have to have a multiple value parameter liked to command query.. any ideas?

Thanks in advance for help!