Para

[EscapeUK]

Happy New Year all

I have a report that allows the user to select a paremeter. That works fine however I would like so that when they have selected that value the options available for selection on another parameter are altered.

For example if the choose A the values in the next parameter are related to A

 

[kenhamady]

Crystal doesn't support this in it's default parameters. But you could code this in your front end and pass your values into the CR parameters. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal

 

[dcm]

EscapeUK: This feature (which we call Dynamic Picklists) has been high on the wish list at Seagate for some time so let's hope V8.5 has it. However, in the meantime a solution we have used before is to associate the picklist with a text file which is itself first generated from an earlier executed report e.g.

Report 1 selects a recording artist and retrieves all albums by that artist and writes out to a text file (TITLE.TXT) which is then used to populate a parameter in Report 2 David C. Monks
david.monks@chase-international.com

http://www.chase-international.com

Accredited Seagate Enterprise Partner

 

[kenhamady]

Dave,

Will that work here?

I am not sure that this will allow prompt B to vary based on the choice for prompt A, since the report to generate prompt list B would have to be run based on what was selected in Prompt A.
Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal

 

[dcm]

Hi Ken

Yes this should work fine as the 2 prompts are in defferent reports at different stages of the process. To clarify:

Report A is based upon a database of artists and has a prompt for the artists name. The selected record is then output to a text file which is used as one of the tables in Report B

Report B has the join to Text A restricting the database to only the chosen artist and outputs that artists albums as a further text file B which can be used as the origin of the prompt in Report C and so on David C. Monks
david.monks@chase-international.com

http://www.chase-international.com

Accredited Seagate Enterprise Partner

 

[kenhamady]

Dave,

I have seen you describe this process several times and I am curious. How exactly do you get a parameter field to automatically display the values in an external text file?

It doesn't sound like you are importing them. Just linking it as a table doesn't affect the parameter field. What's the secret? Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal