Successive Prompts in Crystal Report Viewer

[highlighter]

I need to create 5 prompts for a report.
Prompt #1. Product Name
Prompt #2. Product Version
Prompt #3. Version
Prompt #4. Release
Prompt #5. Suffix
For example, Product Name = DB2, Product Version = DB2 for OS/390, Version = 7, Release = 1, Suffix = 112

I want the user to be able to choose:
- a single value for Product Name
- multiple values for Product Version, which are dynamically generated according to the selected Product Name
- multiple values for Version, which are dynamically generated according to the selected Product Name and Product Version(s)
- and so on for Release and Suffix
- prompt #2 will appear once the user has selected from prompt #1, prompt #3 will appear once the user has selected from prompt #2, etc.

The report is retrieving data from a SQL server. What do I need to do to program the Crystal Report View to accomplish dynamically generated successive prompts for the user?

 

[lyanch]

You can't do it directly within the viewer. You can however do this outside crystal and then feed the results to crystal. Search both this forum and "Crystal reports 4 other topics for dynamic and you should find numerous comments on dynamic picklists.

Lisa

 

[IdoMillet]

My DataLink Viewer provides this functionality:

http://www.milletsoftware.com/DataLink_Viewer.htm

Cheers,
- Ido CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com