User based picklists in Crystal Enterprise 8.5 1

[synapsevampire]

I'm seeking help and advice on how to accomplish the following:

Allow for user based picklists. Meaning that when a user selects a report to run, the choices within a given parameter are populated based on a table driven set of picklist choices available.

I'd like to accomplish this from a CSP page.

Apparently CE can use a text file for a picklists for reports, so that's an option. This becomes very messy with numerous users, reports and parameters.

Any thoughts?

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[rhinok]

Since you're going to have to identify those elements common to as many users as possible, I'd recommend basing the reports on User Groups instead. With that being said, why wouldn't you simply create multiple versions of the report that are specific to the appropriate User Groups?

Of course, you still don't have dynamic parameters...

 

[Guest_imported]

SO, are you saying that Crystal doesnt support dynamic pick lists without writing some ASP (CSP) ourselves ?
<sigh>

 

[synapsevampire]

rhinok: Was this a mis-post?

I'm inquiring about CE picklist generation, not a Crystal Report creation.

britbear:

Exactly, or some external process. You can base them on text files, but you'd have to have an external process create these.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[rpolunsky]

In order to have dynamic picklists (in the generally accepted meaning of that term), you have to have an additional database connection to define the source and output of the picklist. That's not part of Crystal Reports, and it's not a built-in function of CE either. At least within CE you can code your own function to do it.

We've put together an application in-house designed to quickly take a bunch of reports and put them on the web, with a step in the middle allowing us to define dynamic picklists for the parameters. Your mileage may differ.