Limiting Parameter Options 1

[BTSTeam]

Hello

I am using CR XI connected to a SQL database.

I have a dynamic string parameter which uses the DESCRIPTION field from the POINT_OF_CONTACT table as its data source.

The POINT_OF_CONTACT table also includes the STATUS_ID which indicates whether the DESCRIPTION is current or unused.

I would like to limit the DESCRIPTIONs available to the user when selecting the parameter by only displaying those where STATUS_ID = Current.

Is this possible?

Thanks,
Andy

 

[briangriffin]

Create a command object:

select description from point_of_contact
where status_id = currentvalue

In the database expert, make sure the command isn't linked to any other table.

Then base your parameter on the command, everything else works the same. You'll probably have to delete the current parameter and recreate it; sometimes it's difficult to modify dynamic parameters.

 

[BTSTeam]

Excellent - just what I needed.

Many thanks,
Andy