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?
This is new to me so need help. I usually use a static 'List of Values' for my reports. This time, I am needing to use a dynamic 'List of Values' but I need to also have an option that will select 'ALL' if the use doesn't select a value from the list. I know how to do it using a static 'List of Values' by adding the option to the pick list of "ALL" and then test that in the code if they selected the 'ALL.
IP Logged
