Dynamic Parameter List 1

[bpngo]

I have a table that contains a list of doctors. Each doctor can work in one of four regions. I would like to limit the number doctors in my dynamic parameter list by only including doctors in region 2 (region is a field in the table). The report uses many tables. Is there an easy way to accomplish this?

Thanks for your help.

 

[fisheromacse]

in your select expert, use a statement like this:

{Table.Region}=2

 

[briangriffin]

I read this as asking how to limit the doctors in the dynamic parameter to region 2.

If so, I would create a command object but don't link it to anything. The statement would be:

select doctorname from doctortable where region = 2

In the dynamic parameter choose doctorname from the command, and the record selection would include:

doctorname = {?Doctor}

 

[bpngo]

Thank you for the responses. Creating a command object worked perfect! Thanks briangriffin! I've never used command objects before. Opened up a whole new world.

Brian