Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Multiple parameter question Post Reply Post New Topic
Author Message
tin337
Newbie
Newbie


Joined: 04 Nov 2011
Online Status: Offline
Posts: 11
Quote tin337 Replybullet Topic: Multiple parameter question
    Posted: 13 Feb 2012 at 11:58am

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….

IP IP Logged
IdoMillet
Groupie
Groupie


Joined: 26 Oct 2007
Location: United States
Online Status: Offline
Posts: 99
Quote IdoMillet Replybullet Posted: 18 Feb 2012 at 2:58am
At least one of the 3rd-party Crystal Reports viewers listed at http://kenhamady.com/bookmarks.html provides a special cascading and dynamic parameters functionality that solves these types of scenarios. It allows you to design Crystal reports that act as parameter dialogs. In your case, the main report will have a single parameter that uses another report, and that other report will simply have two parameters.

Edited by IdoMillet - 18 Feb 2012 at 2:58am
view, e-mail, export, burst, distribute, and schedule Crystal Reports.
www.MilletSoftware.com
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.016 seconds.