Rahul,
Thanks for the information. Really helped but something is not working.
I created a new command object using this code.
select '...ALL' as NAME_LAST_FIRST_MIDDLE
from sbs_reports_reg_style_v
UNION
select Name_Last_First_Middle
from sbs_reports_reg_style_v
I then created a new parameter field called ‘Person’, dynamic and used the new command object that had the one field “NAME_LAST_MIDDLE” listed to select to populate the dropdown.
In the select expert I added this code:
{Command.NAME_LAST_FIRST_MIDDLE} = {?Person}
When I run the report, the selection box comes up with the proper list of names and the choice of ‘…ALL’. This is great.
But when I select a person, the report starts reading the data and never selects a record. I have to stop the report as it keeps going and going.
Before I changed the parameter to use the command object and only use the table field it worked.
What am I missing?