Hi,
I have an Interactive Report on a page that shows a set of data, with one column being "Requestor" (and shows a username).
I want all my users to have the ability to see all of the data, but also easily access a saved report called "My Requests" in the 'Reports' select-list/drop-down.
I KNOW that it is just easy for them using the Interactive Report to click on the "Requestor" column heading and filter by their own name, but they business users would really like to see a pre-saved report so they can choose "My Requests".
So I am wondering if I can use an application or page item to filter the report and save this? I know that if you are building a URL link that links to the Interactive Report from another page, you can do this (as the application would replace &APP_USER. in the URL before it is created), but is there a way to save the setting in a 'Saved Report' so the user can choose it instead of the Primary Report?
I would like to save this report as a 'Default Report Settings' > 'Alternative' for all users, where my "Requestor" column is like :APP_USER.
Has anyone accomplished something like this?
Amanda.
APEX Version: 4.2.0.00.27