Can anyone help me know how to accomplish this. I created a report with drilling turned on. If the user were to drill down say 2 levels and refresh the report with new values, the data returned starts from the level the left off at, Is there a way to get the report to revert back to the top of the hierarchy?
You may have to educate the user community. To make it a bit of a neater solution, you could initially save the report purged without data, and have it refreshing on open.
(BOB member since 2004-01-29)