If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

[Solved] [RS] Cascading In Range Date Prompts

Started by cognosjon, 25 Jan 2007 04:55:50 AM

Previous topic - Next topic

cognosjon

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

MDXpressor

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.
No, a proof is a proof. What kind of a proof? It's a proof. A proof is a proof, and when you have a good proof, it's because it's proven.

-Jean Chretien

cognosjon

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