I have a summary report that uses a calculation using the current date and time. When I press the
refresh button, the value changes with the changing current date and time. eg. Current date and time - minus - Date A.
That's all fine.
I then do a drill-down to a detail report that uses the same calculation. The first time the value is correct.
However, if I go back to the main report, and then call the drill-down report again 5 minutes later, the calculation in the called report
has not changed by 5 minutes as it should. It shows the same value (current date and time - minus - Date A) as
when it was called the first time.
Is there some sort of cache that we need to change, to use the later time?
Thanks very much for your answer. I did try that and it made no difference. When I run the detail report by itself (with the
same input filters) the current date and time is updated, but when I run it as a drill-down, the current date and time is taken
from the first time I drilled down to it.
Could you think of anything else it might be?
When you return to summary Report,can you refresh once before drilling to Detail report.As calculation is based on current time and date,might be it is taking value from main report which was refreshed 5 mins back
Yes, good thought, but I do refresh the main report and then go down into the drill-down report, and yet
it still shows the original time from the original drill-down - very strange.