How do you create a prompt that filters on date 1

[hoohay]

Does anyone have advice on how to:

Create a prompt that shows only the valid or existing 'transaction dates' for a given 'Company' which has been chosen in a previous prompt?

Can this be done?

Thanks for your input.

hoohay

 

[nlim]

yes, real easy.

First create report R1 that at least has transaction Dates on it. Use a country prompt as the filter for R1. When you run R1, you should be prompted for the country. After your selection, R1 should list the "valid" tranasaction dates. You might have to build in some logic here to identify what "valid" means....

Then create a filter F1, and drag R1 into this filter.

Finally create a prompt P1 that chooses from attribute element list. pick transaction dates, and use F1 to restrict the pick list.

Now when you use P1, you will be prompted for country. R1 will run and return the transaction dates as the pick list for the prompt P1.

Now when you want to change what valid means...you just change R1. If you want to add new prompts in addition to country, you just add them to R1...Highly efficient and elegant design.

 

[hoohay]

Thanks nlim,

I would never have thought of this approach. thanks again for another dead on reply!!!!

hoohay