Dynamic conditions on reports
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-07-2017 10:19 AM
Hello,
I would like to make a report once and use it across orgainztions in my company.
I would like for the condition/filter on the organization to be selectable by the user instead of hard coded in the report...
At this point I have to create the same report for each orgainzation where I hard code the organization in each report. If I ever have to make a change I have to then adjust every report for the one change...
Maybe there is something I dont know?
- Labels:
-
Reporting
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-07-2017 10:27 AM
Is the organization an attribute of the logged in user's sys_user record? If so you can leverage that as part of the conditions on the report.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-07-2017 10:30 AM
Just another follow up, if you own Performance Analytics Premium, there is a feature called interactive filters that you can use:
A solution I created a few years ago could be a solution for you as well:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-07-2017 10:51 AM
Regan,
You can set an attribute to be dynamic in the condition builder. As an example, I am referencing the incident table and created a report that will only display incidents that are assigned to a group the user is a member of. If the attribute is not set to be dynamic, you can create a dynamic filter as needed.....so you can move away from hard coding your reports.
Hope this helps...
Ashby
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-07-2017 11:50 AM