I'd like to show some custom reporting on the Group Details page, is there a bit of SQL magic I can weave to filter the report to only members of the current group being displayed?
Yes, this is possible. When I tried it, I needed to put the condition in the report itself. When you put the report in the "Report from Orion Report Writer" resource on a Group Details page, the ${Name} macro will be replaced with the name of the current group. You can use this in a condition in the report filter, like this:
Anyone?
Have you searched through the Report Lab forum yet? If not, check it out. You might find some helpful stuff in there.
Thanks,DH
It sounds like you are trying to dynamically generate a report based on the group page that you are viewing. From what I understand of the report writer you won't be able to do dynamic report generation like that.
The best that you could do was create whatever report you want then use a WHERE clause to only show the results for that particular group. Once the initial report is created it would be trivial to duplicate it for the other groups (only one or two changes necessary for each one). That would likely be the best that you could do to have each group view with its own report.
I know this is not possible in the report writer itself, but when adding a "Report from Orion Report Writer" View you have the option to add some SQL to filter the results.
When your looking at the details of a node theres variables you can use such as ${IP_Address} to pull that information from the database.
Is there such a variable available I can use to limit what the report is run on when looking at a group view. So far I'm creating report views for the 150+ customers we have, I'd like the ability to create one set of reports and display it on the groups view page and filter it to show only devices in the group your looking at.
