03-17-2015 03:53 PM
How do I add prompt to filter in Query setting. So when users open the report it prompts them to input two date values. I created the prompt in Prompt Manager. Below is the image of where I want to use my prompt.
03-17-2015 04:04 PM
In Options menu you will have the prompt option, there you can had your prompt, then after you will be able to filter using the macro variable defined by the prompt (&yourprompt)
03-17-2015 04:27 PM
Thank you. I applied your setting and it worked but no data were shown. Any idea? Below is an image of my Promp_1 setting and the structure of the date/time variable.
Need further help from the community? Please ask a new question.