Reporting/Intelligence - how to add Date prompts

[Ashfia]

How do I Date prompts to an existing report? I have a scheduled report to list all the "Paid Expenses" for the month at the end of the month. Some staff want a similar Adhoc report where they can select different travel start/end date ranges.  

[Josh · Accepted solution]

Hi @Ashfia,

Welcome to the Concur community!

To do this, you'll first need to click on the filter line of a report:

Then, when the filter dialog comes up at the bottom, check this box:

Save the filter, then save the report. The next time you or anyone else goes into the report, they will be greeted with a prompt to input a date filter.

Hope this helps!

[TRedman]

Here is a link to a video on ConcurTraining.com which walks you through adding prompts to a report using Query Studio.  http://assets.concur.com/concurtraining/cte/en-us/cte_en-us_rpt_dynamic_date_range_prompt_query_stud...

[ELEIBLE]

Hi TRedman,

I have a report that i built in query studio. Do you know if there is a way to schedule an email to be sent that has my report attached ? I've figured out how to email the report, but can't figure out how to schedule the report to be sent daily, weekly, monthly etc. Any help you could provide would be much appreciated.

Thanks

[ELEIBLE]

Adding a little more information. I have write access in cognos reporting, but i'm not seeing the little green schedule icon below. Not sure if this is an access issue or what ?

[TRedman]

You will need to have a Cognos Professional Author role to enable the scheduling feature, this is not available to users with a Cognos Business Author role.  To confirm what you have, you can run the standard report, Employee Roles found under the administration folder.  

If you do have the Cognos Professional Author role, next confirm you are using Internet Explorer. Several features do not function properly under other browsers.  If you are still unable to schedule, log a support case for our Analytics Support team to investigate further.