Mixing Static and Dynamic Cascading Parameters

[Former Member]

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

[Former Member]

Abhilash,

I thought that might be the issue, it seems command parameters just do not play nice with dynamic parameters at this level. I had also gone the subreport route to no avail. Another method I had tried was, since I'm loading these reports into a crystal server, loading the date parameters before generating the report. Unfortunately it appears this will only supply them for the first prompt, with the second being blank. I'll be sure to update this thread if I find a suitable workaround. As always, thanks for the help.

[abhilash_kumar]

Hi,

You've already figured this out! Well, you cannot have a date range parameter setup as dyanmic - it just won't give you that option.

Another option would be, like you said, to use command parameters, however that means you get prompted for parameters twice!

Another approach, although I knew wouldn't work, is to use Subreports. I added the date range parameter in the Main report whereas in the Subreport I added a command object with command parameters. Since this has to be a date range parameter, I created two formulas in the Main report to get the start and end dates finally linking them up with the command parameters.

Although i was able to link the Main report formulas with the command parameters, I still get prompted twice, so perhaps it just does not pass the values to the command parameter.

I don't think we can create a dynamic cascaded parameter with a date range on Level 1.

-Abhilash