This content has been marked as final. Show 4 replies
Use now() instead of current_date.
Appreciate if you mark as correct :)
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.