[Closed] Filtering a prompt based on the selection in another prompt

[maverick_hs]

Hi,

I have a prompt which lets the user choose a calendar month and another prompt which lets him use a fiscal month (the two need not be the same month). What I want is if the user chooses Calendar Month of June 2005 then he should only be able to see the fiscal months 2005M01 to 2005M12 i.e. within the same year.

I know how to use cascading prompts but this isn't really a cascade problem. Seems like I should extract the year from the calendar date parameter and use it to filter the available options for the fiscal month prompt. When I try to create the filter I get an error as soon as I click on the parameters tab...

Any ideas?

[Near]

Hey,

You might try using a reprompt to pre-filter your second query.  When clicked your current page will be refreshed and all querys will be executed after the user has select or made a choice fom the first query prompt.  That value is then used (passed) to the filter in the second query. 

Note: Reprompt is a property of the prompt button that will normally default with the "Next" attribute.  Just change the selection to Reprompt. If the discription "Reprompt" doesn't make sense to your users, you can drop a text item on the button and rename it to whatever you like.

Hope this is helpful and answers your problem?

[Near]

Hey again,

This error may also be caused by a data type problem. Make sure the data types are the same.

[maverick_hs]

Thanks for the suggestion. I will try that out.