Posts

Dynamic filter on Interactive Reports

Image
This feature will allow you to select a row on one Interactive Report and add a filter a second Interactive report using the selected value. This can be achieved easily with a Master Detail Page, APEX will use interactive grids for this, but if you want to use two interactive Reports or if your filter value doesn't come from a report, you can use the solution on this post. This is the demo app , if this is what you are looking for, keep reading the blog. For this example we'll use two interactive reports and one item to store the selected value. In this case we have the Department and Employee Reports, when the user clicks on one department, the employee report will be filtered by the department name. First, in the Department report, set the following properties on the column you want to use as link: Type: Link Target Type: URL URL: javascript:void(0); Link Text: <span class="name-filter"># DNAME #</span> Link attributes: d...