Hi All,
I have a report with a number of prompts.
When I run the report, cognos viewer asks for a Date Range (Start Date and End Date prompts) prompt even though there is no such prompt present in the report.
There are no StartDate and EndDate parameters present in the report, but report still displays this prompts while running.
StartDate and EndDate parameters are defined in a Business Layer query subject for some query items. When I use any query item in the report from this query subject, the report asks for Start Date and End Date even though the query item used does not have this parameters.
Please help me as I am tired of this issue.
When you have filters in a query subject, you are eliminating the Minimized SQL functionality, and the Query Subject will now act like view, so regardless if you use these items in your query, the query subject itself is bound to the restrictions placed on it by having an embedded filter with parameters.
I suggest removing the filters from your query subjects, and create model filters that can be leveraged via click-n-drag in report authoring.