My report consists of several several queries with joins and I have used a date filter on some of them (using #prompt). When I run the report, it prompts for date selection and takes less than 10 seconds to complete.
If I create a prompt page, add a date prompt (use existing parameter) and run the report, it is still running for the last 20 minutes and has not yet finished.
View tabular data on final query after adding prompt page also takes less than 10 seconds.
Want to check if you anyone has come across this strange scenario.
Thanks in Advance.