Stored Procedure for Parameter Drop Down

[jbarbato]

I am using Oracle 10g, OLEDB driver, Crystal xi...

I have a user parameter (project_number) that I created. I have a stored procedure pkg$vpd.set_oid_username that is passed in a parameter at runtime. this procedure allows the user access to all of the project_numbers. This is all working great - I would like to create a drop down list for the project_number user parameter, but everytime i try to append the values of project_number, crystal crashes! any suggestions of how i can get the drop down list to call the pkg$vpd.set_oid_username before trying to populate?

thanks!!!

 

[dgillz]

Crystal 11 supports dynamic drop down lists for parameters. You don't need to do anything special to make this happen.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

 

[synapsevampire]

Sounds buggy if the SP works elsewhere.

Try switching to the Crystal supplied Oracle ODBC (assuming that CRXI still has it) or the Crystal supplied Oracle native driver.

-k