i have created a prompt window of 3 prompts (branch,Analysis year and policy number) but, while running the report an extra prompt page which is asking for analysis year alone before going to the prompt window which is created.
Note : i used analysis year parameter in one of my filter condition.if i remove that filter i am not getting that extra prompt page but the filter is must needed cant delete it.
so please guide me how to overcome this issue.
Can you check the parameter name of year prompt and the the query where you used the filter
Also check if the filter is 'required' or 'optional'.
Make sure there is not an extra parameter referenced in the queries.
Also, as someone mentioned, if the prompt is defined as 'Optional' make sure the filters is 'Optional'. Same for Required.
The other posts have hit the mark but this might help explain what's going on ...
The extra prompt page is a 'friendly error message' indicating that your Analysis Year parameter is not being catered for by either the prompt page or the report query. This is causing a 'gap' in the code gerenated by the report query which throws the extra prompt page.
So why isn't the gap being filled? Three common reasons are:
- An extra parameter - caused by a misspelling between the parameter in your filter and the parameter selected in the prompt control (yours is on the prompt page).
- These must be identical
- Parameter names are case and space sensitive
- Any difference will result in two parameters
- Check the spelling of the parameter in the extra prompt page and compare it to the the parameter in your filter
- A conflict in the optional/require settings defined for the parameter.
- Check this setting for the prompt object and the filter in your report query
- These must match
- An obsolete parameter.
- Check the spelling of the parameter referenced in the extra prompt page
- Copy your report to clipboard, paste into notepad then search to find out where the obsolete parameter is being referenced in your report.
Possible causes to your particular problema are points 1 and 2.
HTH :)