Selecting ALL in a Parameter field.

[wil1952]

I have a report I am running that list clients by their locality code. I have a parameter set up so the user can select the locality code they want to run the report for. Now the are asking to be able to select ALL and get everyone. How can I do this? Here is my record selection formula:

isnull ({episode.dschg_date}) and
{ep_discipline.admit_ntuc_flag} = "A" and
{episode.company_num} = {?Company Number} and
not ({patient.last_name} like "zz*") and
{episode.locality_code} = {?Map Page Number}

Thanks for any help.

 

[Turkbear]

Hi,
Modify your selection criteria formula to handle that choice ( add ALL to the list of values for the parameter) then

isnull ({episode.dschg_date})
 and
{ep_discipline.admit_ntuc_flag} = "A"
 and
{episode.company_num} = {?Company Number}
 and
not ({patient.last_name} like "zz*")
 and
( 
If {?Map Page Number} = "ALL" then
  True
   Else If {?Map Page Number} <> "ALL" 
    then 
  {episode.locality_code} = {?Map Page Number}
)

Hope it helps..







To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[wil1952]

Great it worked.