How to change default prompt behaviour in a report

By default the date prompt shows the current date in the prompt. So , if you want to run an MTD report or if you want to customize the default date in the prompt as per your requirements.

This document will help you achieve the same.

Solution:

1. Drag a Date & Time prompt in your report and give it any name of your choice(e.g. refer below screenshot, I have given Date1)
prompt1

2. Drag a HTML item on right side of the prompt (refer below). Please note that we are only concentrating on From Date(Prompt name Date1 as given in point 1) and the other prompt will have default current date.

prompt2
3. Paste the script( attached in notepad) in the HTML item where Date1(in green below) is the name of the prompt as in point 1)
prompt3
4. The result will be as below :

prompt4

www.cogknowhow.com