Is it possible in Crystal to change a parameter based on a selection from a previous parameter.
Example:
First Paramter will be a drop down with a list of countries.
Based on the country selected a list of cities from that country will appear.
The only way I can see of getting this type of interaction for the user is by using sub reports, which to me just seems counter intuitive.
BTW I'm a total Crystal newbie
Last edited by DeadEyes; May 27th, 2005 at 06:29 AM.
Hi Kuiltag
Because of the sensitive nature of the of the information I've put together another report based on the Extreme.mdb that comes with crystal which should show you what I am trying to do.
There are two paramaters
1. Country
2. Region
The Country parameter shows all the countries in the Customer table.
After selecting the country I want to select a region but the region parameter shows all the regions and not just the regions for the country previously selected.
The end result of the report is a list of customers filtered by country and region.
So to recap
How can I get the Region parameter to be filtered based on the Country Parameter.
Well I've been using Crystal Reports 10 for about 4 hours now and it won't let me do anything that I thought would be pretty basic.
Default prompt values can be loaded from a database, but once they are loaded they are static.
Cascading prompts are also a no no.
These things do exists in version XI
<rant>
The first time I use the product and it won't let me do what I would consider to be pretty basic/standard. Why the hell did it take 11 versions before they implemented it. Grrrrr
Trying to find workarounds at the very start of a project is pretty *explitive* bad.
</rant>
[Resolved] Crystal Change Parameters at Runtime
Reply With Quote
