Printable View
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
post your sample report and let's see what we can do? also the source,
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.
:mad: :confused: :mad:
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>