Print Page | Close Window

Static and dynamic parameter field

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22276
Printed Date: 19 Apr 2024 at 6:27am


Topic: Static and dynamic parameter field
Posted By: Nils.K
Subject: Static and dynamic parameter field
Date Posted: 29 Mar 2017 at 6:36am
Hi, I want to create a parameter field to select country. This parameter field has 3 values: USA, CANADA, and Others. If user clicks on 'USA' the value will be USA and if clicks on 'CANADA' the value will be CANADA. But it user clicks on 'Others' there will be a prompt for user to input another country. This seems like a mix between dynamic and static, and I don't know if it's possible to do that. Could someone help me?



Replies:
Posted By: DBlank
Date Posted: 29 Mar 2017 at 11:01am
why not just sort them as Canada and USA as the first two then everything else alpha? Otherwise you would likely need to do a cascading param and need some table data to support it.


Posted By: kevlray
Date Posted: 29 Mar 2017 at 11:07am
Well it looks like you want a cascading prompt which I have only done with dynamic prompts.  But there there would be no relation between USA, Canada and others.  Not sure if this is possible, but I have been surprised before.



Print Page | Close Window