Is there a way to build a third parameter list based on results of two previous parameters?
Example: let’s say I have 3 parameters (Year, Location and Sites)
The first two parameters will be entered by the user and the third parameter will be a select list based on the results of the first two parameters.
Let’s say user enter Year 2010 and Location San Jose and based on these first two parameters, the third parameter will produce a list of ‘Sites’ within the San Jose area in 2010 that the user can select from (such as site1, site2, site6, etc.), then based on the conbined 3 criteria, there final report is produced, giving such data points as address, phone, sales result, etc.
Is this possible? I’m currently using Crystal Report 2008.
Thanks for any help or feed back in advance….