I have a report parameter that is currently dynamic.  It offers a list of user login ID's and allows you to select one or more login ID's.

 

I would like to add to this prompt an optional free form entry field for old login ID's that have been purged from the Login ID master list, but still have history in the data base.

 

And I want to do this with one prompt, not two.  I have achieved the end goal with an additional static parameter, but the powers that be want one prompt box.  A problem with two prompts is that when I run the report for a purged Login ID the first paramter for the Login ID from the master list requires an value...

 

Thanks for your ideas!

post 2: you can union an ' All' option to your dyanimc param list and in your select expert you use

 

{?param}=' All'

or

{?param} = {table.useridfield}

 

if youa re using other select criteria you need to parenth this or statement together.

 

I believe that v 2008+ allows for empty parameters. If you are using an older version than that you are stuck with entering something into a param.

I am not seeing an elegant (limited clicking) solution but let me ponder it some more...

Would sorting your pick total list alpha active then alpha inactive be a viable solution? Your active list remains at the top for less scrolling (limits your user process) and it is clear when you pick users which type you are picking...

 

It still creates one parameter witha shorter list to sift through at the top for the active but allows for any user to still be found if needed.

Seems like it should make those powers that be happy...

write a case statement to create your active/inactive user name list

case when table.email is not null then  '(A) ' else '(I)' END + table.userid

 

use this new case statement feild as the source for the dynamic param.