Prompt selection

[naveenshindhe]

Hi,
Using Impromptu 7.0
1. first i need a prompt for date
when I enter the date as 2003-03-07 then I should see the actual dates in
the column heading [i.e. 2/21/03 and 2/28/03].
i.e., last 2 week dates.

2. after entering the prompt for date, i need to give the filter condition.
i.e, Region in (?prompt?)

How to do this, anybody has ideas.
thanks
naveen

 

[sln007]

You have the basics described well.
With the Catalog opened,
* select "catalog" in task bar,
* select "folders" in the drop-down,
* select "prompt" in the 'NEW' area of the FOLDERS window,
* Complete the 'PROMPT DEFINITION' window.
Name=Sample Date. This will be a type-in prompt, and make sure "data type" is DATE.
Open a new report. Select data fields desired. In the FILTER tab create this filter:
(?Sample Date? = REGION_DATE) --> select the prompt from the "Catalog Columns" of the 'Available Components' area, since this prompt is in the catalog.
After the report has been run, you can INSERT "Prompt variables" to where-ever you want to on the report. That way you can see what prompts were used for the report.
It is rather simple after you get the hang of it.
Good Luck. I hope this 'rough' step-by-step helps.