Welcome to the Cognos forum. I'm not sure I understand all aspects of the problem. I'll tackle the two questions separately.Double Prompts
To really understand why this is happening I'd need you to post the text of your filter in the report. Also, are you defining the prompts twice (once for the filter, and again for display in the report)? I assume that each
of the date prompts (both start and end) are appearing twice. There was a version of six that I encountered that had a reported problem I experienced myself with single prompts appearing multiple times, but that was fixed in a RBF release shortly afterwards.Date Formatting
You need the dates in the format dd-mon-yyyy for both
the report and the prompts? Are the prompts
(start date and end date) setup as strings or dates?
Impromptu can handle different date formats for display in the report without converting the dates to strings. Just right-click on the report data and select 'Format' from the dialog option. The date formats offered in the dialog are starting points only. You can customize them as needed. Just type in 'dd-mmm-yyyy' in the 'Normal' box of the format screeen.
The formatting of the prompts is a little more complex. I find it's usually best to leave them as dates, as this allows Impromptu to validate the date before accepting the prompt. I usually handle date prompt formatting and date validation in macros for the real picky users. Cognos provides the following instruction to change the formatting of date prompts (as of version 6 RBF3) in the following instruction, though I have never been able to get it to work myself. (Don't get discouraged. I didn't try too hard). If you follow these instructions and they work for you, you will not even have to change the date formats in the report manually, as Impromptu will follow the regional settings for the date display in the report.
Is it possible to change the default date prompt format for IWR and Impromptu? For example: Date in Prompt Manager is displayed as 2001-01-01 format but would like it to show as 01/01/2001?
As of version 6.0 RBF3 of Impromptu and IWR you can format the date for prompts through the Regional Settings in the control panel. These changes will be reflected after launching the next Impromptu or ImpServer session.
In Control Panel -> Regional Settings, in the Date tab, under Short Date Style, specify the date format desired. This is the format that will be displayed in Impromptu.
Note* Specifying English (United States) regional setting causes the default date prompt value to change.
To work around this, try changing to the English(Canadian) regional setting.
I hope this helps,