Hi,

I am facing strange problem with dashboard with autorun on load and need your assistance please. Below is my issue

I have 2 reports on my Dashboard where as Each report has its own drill through reports. Each report has Date filter and by default date range is "CurrentDate - 1 months and CurrentDate+ 0 months". I have mapped filters correctly to drill through reports.

My problem here is - when I am running the dashboard with auto run on load or reset option, when I go to drill through report from dashboard and return back to Dashboard, Value at date filter is being changed (current date-1 Day and current date) inside SQL.

But on Dashboard filter it is showing as 'current date-1 month and current date'. But if we view the report, then we can see the Date is changed (Current date-1day) in filter parameters and SQL statement.

Somehow the date range is changing from "currentdate-1 month" to "currentdate-1 Day" if we go through drillthorugh and comes back to Dashboard. So the data shown is different when we drill through and comes back to dashboard.

This issue is with first time with autorun or reset button at any time, if you click on "GO" button, there will be no issue.

you can replicate issue with dashboard having 2 or more reports.

Please let me know if you need any additional information. Can you please look at the issue.

Thanks
Jhansi