Adding drop down list to query builder report

[jfrankovich]

How does one get a parameter in Report Builder to display a drop down list for a parameter, as shown in the attached image?
This is an OOTB report for ChangeNotice_ChangeAdmin_NotGiven, and the State condition has a large drop down list, but there doesn't appear to be any way to create these drop downs for other values. - The Help says to use Macro, but using Macro seems to pre-populate the drop down with the irrelevant choices of Current Time and Current User.

I'm trying to create a context based report where the context is chosen from a list.

John

[cid:image003.jpg@01CB42BE.FC85FCD0]

[MikeLockwood]

Total mystery how this happens, but if the system in fact knows what the values are (States, Roles, etc.) then with enough fooling back and forth between Constant and Parameter, it just kicks in. But - It's very hard to get the system back to accepting text for things that should not be drop-downs.

Query Builder is very helpful but has essentially no documentation and is very quirky.


One other note - be careful about using the System Date function (example: use Time Difference days to subtract System Date - Created for any object). The system Date is considered (always) to be 5pm yesterday, resulting in negative results for the time since creation for creation that occurred this morning.