PDMWorks Enterprise Report Generator

For users of PDMWorks Enterprise, you may notice the menu item “Report Generator” under the Tools menu in PDMWorks Enterprise.  There is information in the help about this tool, but in general terms, it allows users to plug in SQL queries to their PDMWorks Enterprise implementation.  For example, if you want to run a report such as:

• Users in a particular group
• Groups that the logged-in user belongs to
• Logged In users (report with License Type in use)
• Assembly Structure of an Assembly
• Complete Where Used report including all revisions
• Documents with Specified Configuration
• Documents in a particular state

These are just a few.  In fact, any SQL query can be turned into a report that can be imported into the Report Generator and executed by regular users.  The Reports are saved in a CRP format.  I have attached examples in a crp file.  (Download PDMWE_Sample_Reports.crp)

Simply double click on this file to import the reports into your current vault.  From there, you just have to select which users/groups will have access to the reports.

To run the report, go to Tools > Report Generator (see screen shot)

Select the report to run and click the green arrow.  If you are running the report on a file, as shown in the screenshot, just drag and drop the file(s) into the report window before running.