Parameter

[TheGoldMineGuru]

BOE XI:

Many of our reports are based on a Rep's name from our database field. This list changes quite frequently, so static parameters are not ideal. I have created a Stored Procedure to pull the lists, which works just fine. However, I also need the list to contain static values, such as ALL, or even a listing of Deparments that come from another field in the database.

If that makes sense, what advice could you give to set this up?

Thank you so much!

 

[synapsevampire]

I don't think that you need an SP, but since you can create database objects, a View containing a UNION could handle this, as in:

(Oracle)
select 'All' from dual
UNION ALL
select choices from table

Now base the dynamic picklist on the view.

Note that you ask about databsaes and don't bother to post your database type or version, so people can't specifcally help you.

You can also base picklists off of Business Views containing a Command Object in BOE XI.

-k

-k

 

[TheGoldMineGuru]

You make it sound like I'm lazy or rude : ). I thought it only worked with SQL since it asks for MSDE or existing SQL Server upon install. I am using SQL2000.

Anyway, the UNION gave me the idea to change my query and it worked great. I appreciate the help.