Skip to Content
Former Member
Sep 14, 2011 at 04:47 PM

Mixing Static and Dynamic Cascading Parameters


I've been having a really rough time trying to find a workaround for this and have found few relevant posts on the topic. Here is what I am attempting to implement. I have 3 dynamic cascaded parameters which I would like to further limit by an initial date range. My query returns a list of activities, each with the relevant parameter information including a date. The problem is that if I add the date as the first dynamic parameter in the cascade the prompt will ask to select individual discrete dates, with no option for a date range. My first thought was to hide this list and provide the values from a static date range parameter, but I am not sure how to pass values from one parameter to another. My second thought was to do a start and end date as command parameters which would limit the record, however this is not ideal as the user will be prompted twice, before the query is run and again upon the cascaded prompt. Any help with this would be very much appreciated.

Edited by: tjohn6 on Sep 14, 2011 6:47 PM