Hello, I created a single report to with 3 different queries each showing details on how many reports were submitted based on country, approved and processed respectively. Now I want to add a date prompt common to all the reports in such a way when user selects particular day, the report should display how many reports were submitted, approved or processed on that particular day. Any thoughts on how can we do this?
Any help is appreciated.
@mamehta I'm not sure what you are asking is possible. If you have 3 different queries running in one report, each query would need to have a date filter related to that query, so trying to build one prompt to return data for 3 different queries might not be possible.
Can you send me a private message with your company name, the report you built and where you saved the report in Cognos, please? I'd like to take a look at the report you built to help give you a more difinitive answer.