Multiple Parameter values 1

[dasiga222]

Hi
I am using Crystal reports 10
I am retrieving the employee details
I will be giving the employee number as the paramater as
for that parameter value I was able to retrieve the values

For example , if passed {?epm_no} value as 10, all the employee with number 10 used to come up
If I entered 50, all 50 employee details were coming
But now, I need the report with slight improvement
Can I pass multiple values to the parameter at the same time?

If I need to view the details of employee number 10, 20 30 and 50 at the same time in the same report
How can pass on all the values at the same time to the parameter {?emp_no}, so that I can view all the employees at once

Thanks

 

[synapsevampire]

Go into the report and select edit the parameter, then turn on the Allow Multiple Values.

-k

 

[dasiga222]

Thanks for your response...
I have an another report with the same functioanlity
Now here I am retreiving the value from a Command as the data source

The Command is
" Select * from emp where emp_no = '{?emp_no}' "
where '{?emp_no}' is the parameter I created in the Command
Now can I make the parameter in the Command as a multiple value parameter
I could make the parameter outside the command as multiple value
Could some please suggest

Thanks

 

[synapsevampire]

Nope, you can't use a multiple parameter from within a Command.

You'll have to rewrite and use the emp table in the report in lieu of a Command and use the conventional Crystal Reports parameters.

You might use an SP as your command object, and pass through comma delimited values and then parse it in the SP, but that's a lot of effort.

-k

 

[TomKSS]

Your information on multiple params is helpful. I have a viewer app which uses a custom built crystal rep. I have the ability to add multiple values in a single data type query such as multiple employee numbers. However, after each entry, I must hit ADD and enter the next value. How can I extract multi entries (csv, tab, etc.) from a file and enter them into my query all at once? I can not get a reasonable answer as to where the Temp parameters file/memory is so I can mass populate it. Thanks, Tom

 

[synapsevampire]

Tom: You should start a new thread for this.

Include technical information, such as:

Crystal version
Database/connectivity used
Example data
Expected output
How your app is being generated and the language used

You speak of adding parameters, but you don't mention whether you do so in your app, or using a Crystal viewer (if so, which viewer).

-k