Parameter Question

[Gizmo0917]

Okay I am using a canned report that I have saved and renamed so I can make changes to it. The report gives me the following information:

Missed Treatment info
Date and Time
Patient Name
Case Number
Work Area

I am only interested in getting the Workarea for those areas related to Pediatrics. I set up a parameter that asks for the Workarea and loaded it with just the PEDs workareas. I set it to allow multiple values and the allow editing of multiple values when there is more than one value is checked. This should work. But when I do a report and choose all the values it gives me information only for the first choice. However, If I choose only one workarea from my list it gives me the correct information for that individual work area. My question is how can I make it show me the information for all my selected choices??

Thank you,

 

[MColeman]

When multiple values is set, the parameter window shows an Add button. The Add button needs to be clicked after you choose each value you want to run for. Then the value is copied from the drop-down box to the text box at the bottom.

If you click each value and not click the Add button, it knows only the last value clicked.

 

[Gizmo0917]

I am clicking the add button.

 

[MColeman]

Is your parameter setup to be a range parameter?

You can check the values getting passed to the report
by printing a comma delimited list of the parameter values chosen by creating a formula

Join({?parmname}, ', ')

and printing it in the report header.

 

[Gizmo0917]

Ok I did this and in the header it shows the values I have chosen but in the report under Workarea it still shows only the first value. Do I now need to put the formula in the Workarea field instead of the Parameter field? then put the Parm field in the header report suppressing it so it doesn't show?

 

[Gizmo0917]

Well that didn't work either. How do I get it to show the different work areas?

 

[Gizmo0917]

So I also tried grouping by workarea and it is showing me all the workareas(Adult and Peds) even those not shown in my parameters! Is it because it was a canned report? What I am doing should work. This is getting frustrating!

 

[lbass]

How did you incorporate the parameter in your select statement?

-LB

 

[Ngolem]

You don't need a parameter for this task

Just go to the Record Selection formula and add the following line

{Table.workarea} in [ "pediatrics1","pediatrics2",..."pediatricsn"] and
....rest of record selection formula ...

where "pediatrics1"..."pediatricsn" are the values for the work areas that you want.

Jim Broadbent

The quality of the answer is directly proportional to the quality of the problem statement!

 

[Gizmo0917]

It Worked!! Thank you so much! I knew the select expert you could Cherry pick but I didn't know you could make it a formula that would automatically fix the report! Thanks again to you both!!