Are 'Dynamic' Pick lists possible to expose to end user 1

[rictorsan]

I need to expose one or more parameters (e.g., Client Name)to users for reports that I will publish to a custom ePortfolio. Is it possible to expose a pick list as a parameter so that new Client Names added to the database are automatically displayed in the pick list ?

How are other people handling exposing data like this that is constantly changing to end users without modifying and republishing each report?

Thanks

rictorsan

 

[synapsevampire]

This is a serious limitation in CE.

You can dynamically populate the choices in a custom CSP page using ADO for instance, and then pass the choices to the report, but Crystal itself won't update them.

There's an example of using ADO to update populate a pick list and passing it along to the report available from CD, I tested it a few months ago.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[sbdavis]

Where can I find the ADO example?

 

[synapsevampire]

Contact Crystal Decisions, they supplied it to me months ago.

I don't have a copy of it here at this contract.

-k

 

[sbdavis]

Is this the ADO example?

http://support.crystaldecisions.com/library/kbase/articles/c2009631.asp

I would have to modify it to work in a custom ASP page, since RAS9 does not support CSP, only ASP.