MULTI VALUES 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,
discipline and
patients.

Initially we had to dispaly data for either one location or all locatations, and one discipline or all disciplines and one patient or all patients.

So we passed only one value of each parameter from UI and it was either id = 0 for all option
OR
a specific id for location, discipline or patient.

Now from UI we are planning to pass multivalue parameters like
for patient display data for id's 234, 345, 456, 546, 456
and
location xxx, yyy, aaa, zzz, ccc, bbb
and
discipline z4, x4, c4, v4.

Initially my code in selection formula was:
(
if {?Discipline} = '0' then
{view.Discipline} = {view.Discipline}
else
{view.Discipline} = {?Discipline}
)

and

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

and

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

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

Thanks in advance

 

[dgillz]

To display MV parameters in CR* or newer:

Join({?MVParmField},","})

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com