We need to add a custom report to the flexnet manager console reports tree that is more complex than the built in report writer can handle. We are able to write the sql which can be turned into a viewtable. But I cant find a way to add it to the grid_view list of reports to be run in the console.
‎Feb 04, 2022 03:47 PM
You can also use this as a reference for how to create a custom FNMS report from scratch
‎Feb 06, 2022 03:43 PM
Here are some further posts which may help as examples to provide inspiration for configuring a report using a direct SQL query:
‎Feb 06, 2022 06:30 PM
Easiest way I can think of is to create a custom report in the UI with field names that are similar to the one in your SQL view. You can then search for the report in dbo.ComplianceSavedSearch and update the SearchSQL field with whatever you want to run. You just have to make sure that the column names from your SQL output are in sync with the expected column names in the UI report. There's probably a way to change the column names too, but off the top of my head I'm not sure
‎Feb 06, 2022 03:35 PM
You can also use this as a reference for how to create a custom FNMS report from scratch
‎Feb 06, 2022 03:43 PM
Here are some further posts which may help as examples to provide inspiration for configuring a report using a direct SQL query:
‎Feb 06, 2022 06:30 PM