Skip to Content
0
Former Member
Jan 16, 2013 at 04:44 AM

Parameter field and case statement

13 Views

Hi

I have a report where it display all the jobs with following information

jobnumber

jobtype

pm (project manager)

ca (contractsadministrator)

Report is sorted by pm and group by ca

New Requirement:s - prompt user to enter job type and display report with selected job type.

Now, there are two job types i.e. large and small. User want to display report with both job types selected as well.

So I created the parameter field and put static values. I allowed multiple values and it works.

Problem - User want to have drop down menu to select following instead of selecting multiple values

Large

Small

Both

What should I do in select expert? use case statement? Is there any example that you can refer to?

Thanks

Angad