Does anyone know of a way to get dynamic picklists for parameters functioning from a Compiled Report. I am limited to running the report (compiled) from the desktop - not from a Web Server. I would like to run a SQL script (from a file) which would populate the picklists based on some criteria. Is this possible to achieve possible via API calls? Thanks in advance.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Dynamic Parameter pick-lists
- Thread starter scarmody
- Start date
- Thread starter
- #3
Not yet. I know you can modify the contents of the picklists via API calls (from a VB app for example). But you have to save the report with its modified contents. I have many such reports that I need to use this functionality for. This seems to me a MAJOR limitation of Crystal. Not everyone runs reports off of the web.
It's not in Crystal and it's not going to change because Compiled Reports / Report Distribution Expert are moving out of the product. With V8/V8.5, you have to download the software from Crystal. It's no longer in the shrink-wrapped version.
In VB or ASP, create a drop-down box, populate it from the database, and pass the selected values to the report.
In VB or ASP, create a drop-down box, populate it from the database, and pass the selected values to the report.
- Status
Similar threads
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question