I have a requirement for a prompt page with an in range date prompt that is a cascade source to a value prompt.
So for example the user selects a date range and is then presented with a list of works orders created during this date range.
I understand that I cannot make this type of date prompt autosubmit and have tried to use a reprompt button, but with no success.
Any suggestions on how i could achieve this?
cheers ;D
jonathan
Jonathan
Hi Johnathan,
The 1st thing you will need to do is create a query to serve your cascaded prompt. Filter this query using your in_range parameter. Include as your 'Use Value' the data item you want to be able to select and pass to your Report Query (Work Order# for instance). Add (if you so choose) a descriptive data item to provide as a 'Display Value'. A further option may be to include a data item to use as a sort control (whose pre-sort property is appropriately set), but really only the 'Use Value' data item is necessary.
Next you need 2 prompt pages. 1st page presents the prompt to satisfy your in_range parameter. There should be nothing complicated about this prompt, a simple date prompt whose UI is set to In_Range, it will serve as the cascade source for the 'Use Value' prompt you will place on the 2nd prompt page. So, with PP1 created, drop a value prompt onto PP2. Connect it to your Prompt Query, supply the Use Value (and Display Value if available). Now set its Cascade Source to your in_range parameter.
That's it. You should be done now.
Hopefully I didn't miss anything, but let me know if doesn't work.
Cheers for that I was obvioulsy having a mental block with that. I've instead of using two prompt pages simply made use of a reprompt button and hey presto working as it should. Thanks for the kick in the right direction.
;D