Does CR 8.5 supports/Handle Multi value parameters?

[khan007]

I am on CR 8.5, WIN 2k, Active x viewer, JSP environment.

I am facing problems to display data with multi value parameters.

I have reports with parameters location and patients.

I am running it from a JSP page and it is parameter driven.

Initially our only options from web page were either display one or all, means either one location or all locations, and one patient or all patients.

Now we changed our UI and user gets a pick list to choose from. The list is predefined and has all the possible selections of locations or patients they can choose.

Initially my code in selection formula was:

// we used ‘0’ for all option.

(
if {?Location} = '0' then
{table.Location} = {table.Location}
else
{table.Location} = {?Location}
)

and

(
if {?Patientnumber} = '0' then
{table.Patientnumber} = {table.Patientnumber}
else
{table.Patientnumber } = {?Patientnumber}
)

Now my questions is how could I handle multi values parameters in my report.
For example, if user pick five patientnumber 234, 345, 456, 546, 456 and three location base1, base2, base3 then how I am I going to retrieve these parameters in my report and query my selection formula.

Please inform me how could i pass multi value fields in crystal reports.

Please tell me is it possible in CR 8.5 or not.
I have used :

(
if {?Patientnumber} = '0' then
{table.Patientnumber} in {table.Patientnumber}
else
{table.Patientnumber } = {?Patientnumber}
)

and it worked fine with number, but string is not working in that formula.

Please inform me with any logic.

Thanks

 

[synapsevampire]

Did the CD Java zone not answer your question?

The discrete parameters shows:

/Add the new value to the parameters current values collection
tempParam.getCurrentValues().add(newDiscreteValue);

Is that not what you seek?

I had posted:

Check this page:

http://www.crystaldecisions.com/products/dev_zone/java/downloads.asp

You can either construct the record selection formula and pass it, or pass parameters.

-k

 

[khan007]

ok, Thanks a lot, I didn't get a chance to look at your earlier post.

I will read this article and will try to resolve it.
Thanks.

 

[khan007]

I read the whole article regarding the discrete parameters.

As a report designer i have to do everything on report side and my manager is not intrested in modifying any single line of code on JSP side.

They are just sending me each parameters with a delimiter (,) and these parameter could be either string or numbers.

Like
Patient# would be (101, 102,103,104,105)
Discipline (AUD, PT, OT, SP)
Location (base, Upper, LOwer, DCH)
UNID (401H, 099D, 990K, J980)

So it means i need to handle all these multivalue multiple type parameters on report side and need to create a formula on record selection formula.

Please advise, as I mentioned earlier I am easily taking care of business when they pass either 1 parameter or all but need some formula or logic for more than one.

Thanks