{"id":75990,"date":"2026-07-15T08:00:55","date_gmt":"2026-07-15T12:00:55","guid":{"rendered":"https:\/\/www.javelin-tech.com\/blog\/?p=75990"},"modified":"2026-06-30T14:11:03","modified_gmt":"2026-06-30T18:11:03","slug":"how-to-use-the-report-generator-in-solidworks-pdm-professional","status":"publish","type":"post","link":"https:\/\/www.javelin-tech.com\/blog\/2026\/07\/how-to-use-the-report-generator-in-solidworks-pdm-professional\/","title":{"rendered":"How to Use the Report Generator in SOLIDWORKS PDM Professional"},"content":{"rendered":"<p>The Report Generator in <a href=\"https:\/\/www.javelin-tech.com\/3d\/technology\/solidworks-pdm-professional\/\">SOLIDWORKS PDM Professional<\/a>\u00a0enables you to query and display information stored in the database server. However, this remains a largely unknown feature to even the most experienced administrators and users.<\/p>\n<p>Accessing the Report Generator in SOLIDWORKS PDM Professional will take you further into harnessing the full capability of SOLIDWORKS PDM.<\/p>\n<h2>What is the Report Generator?<\/h2>\n<p>The Report Generator in SOLIDWORKS PDM Professional allows users to create, save, and print reports from file information in the vault. The extension is generally .crp, and results are shown in the pane of the Report Generator.<\/p>\n<p>Results can then be exported to comma-separated value files and imported into spreadsheets or other database tools. To properly generate reports, you will need to know how to format the query, create a transaction query, and finally execute the report query.<\/p>\n<h2>Opening the Report Generator<\/h2>\n<p>The Report Generator can be accessed after logging into a local vault view for your SOLIDWORKS PDM vault. From there, open the Tools menu and select Report Generator.<\/p>\n<div id=\"attachment_76013\" style=\"width: 410px\" class=\"wp-caption aligncenter\"><img decoding=\"async\" aria-describedby=\"caption-attachment-76013\" class=\"wp-image-76013 size-full lazyload\" src=\"data:image\/gif;base64,R0lGODlhAQABAIAAAAAAAP\/\/\/yH5BAEAAAAALAAAAAABAAEAAAIBRAA7\" data-src=\"https:\/\/www.javelin-tech.com\/blog\/wp-content\/uploads\/2026\/05\/Image001.jpg\" alt=\"Accessing the Report Generator feature\" width=\"400\" height=\"483\" title=\"\"><p id=\"caption-attachment-76013\" class=\"wp-caption-text\"><noscript><img decoding=\"async\" class=\"wp-image-76013 size-full lazyload\" src=\"https:\/\/www.javelin-tech.com\/blog\/wp-content\/uploads\/2026\/05\/Image001.jpg\" alt=\"Accessing the Report Generator feature\" width=\"400\" height=\"483\" title=\"\"><\/noscript> Accessing the Report Generator feature<\/p><\/div>\n<p>If you have never used this feature before, you may not see any reports available to use. Without sufficient permissions, you will also be unable to import new queries.<\/p>\n<p>&nbsp;<\/p>\n<h4>Administrative Permissions for the Report Generator<\/h4>\n<p>If you need to add new or administer existing report queries, you need to have sufficient privileges in the vault. This can come from either user or group permissions.<\/p>\n<div id=\"attachment_76011\" style=\"width: 610px\" class=\"wp-caption aligncenter\"><img decoding=\"async\" aria-describedby=\"caption-attachment-76011\" class=\"wp-image-76011 size-medium lazyload\" src=\"data:image\/gif;base64,R0lGODlhAQABAIAAAAAAAP\/\/\/yH5BAEAAAAALAAAAAABAAEAAAIBRAA7\" data-src=\"https:\/\/www.javelin-tech.com\/blog\/wp-content\/uploads\/2026\/05\/Image003-600x377.jpg\" alt=\"Updating permissions to add new report queries\" width=\"600\" height=\"377\" title=\"\"><p id=\"caption-attachment-76011\" class=\"wp-caption-text\"><noscript><img decoding=\"async\" class=\"wp-image-76011 size-medium lazyload\" src=\"https:\/\/www.javelin-tech.com\/blog\/wp-content\/uploads\/2026\/05\/Image003-600x377.jpg\" alt=\"Updating permissions to add new report queries\" width=\"600\" height=\"377\" title=\"\" srcset=\"https:\/\/www.javelin-tech.com\/blog\/wp-content\/uploads\/2026\/05\/Image003-600x377.jpg 600w, https:\/\/www.javelin-tech.com\/blog\/wp-content\/uploads\/2026\/05\/Image003.jpg 739w\" sizes=\"(max-width: 600px) 100vw, 600px\" \/><\/noscript> Updating permissions to add new report queries<\/p><\/div>\n<p>Ensure that you have &#8220;Can update report queries&#8221; enabled under the Administrative Permissions tab. This would need to be added for every user or group that would be interacting with the Report Generator.<\/p>\n<h2>Importing Report Queries<\/h2>\n<p>After opening the Report Generator, you can then import new queries to run. If none exist, there are default queries included with SOLIDWORKS PDM so you can learn how to generate reports.<\/p>\n<div id=\"attachment_76010\" style=\"width: 610px\" class=\"wp-caption aligncenter\"><img decoding=\"async\" aria-describedby=\"caption-attachment-76010\" class=\"wp-image-76010 size-medium lazyload\" src=\"data:image\/gif;base64,R0lGODlhAQABAIAAAAAAAP\/\/\/yH5BAEAAAAALAAAAAABAAEAAAIBRAA7\" data-src=\"https:\/\/www.javelin-tech.com\/blog\/wp-content\/uploads\/2026\/05\/Image004-600x338.jpg\" alt=\"Example query in the default SOLIDWORKS PDM installation\" width=\"600\" height=\"338\" title=\"\"><p id=\"caption-attachment-76010\" class=\"wp-caption-text\"><noscript><img decoding=\"async\" class=\"wp-image-76010 size-medium lazyload\" src=\"https:\/\/www.javelin-tech.com\/blog\/wp-content\/uploads\/2026\/05\/Image004-600x338.jpg\" alt=\"Example query in the default SOLIDWORKS PDM installation\" width=\"600\" height=\"338\" title=\"\" srcset=\"https:\/\/www.javelin-tech.com\/blog\/wp-content\/uploads\/2026\/05\/Image004-600x338.jpg 600w, https:\/\/www.javelin-tech.com\/blog\/wp-content\/uploads\/2026\/05\/Image004-768x433.jpg 768w, https:\/\/www.javelin-tech.com\/blog\/wp-content\/uploads\/2026\/05\/Image004.jpg 946w\" sizes=\"(max-width: 600px) 100vw, 600px\" \/><\/noscript> Example query in the default SOLIDWORKS PDM installation<\/p><\/div>\n<p>The default SOLIDWORKS PDM installation directory includes a file with multiple reports bundled inside of it, but additional queries can be downloaded from the <a href=\"https:\/\/support.3ds.com\/knowledge-base\/?3dssid=01fabdb1-f0f6-495e-b65e-06344abbbaeb&amp;3dsvid=c86c6625-1f36-4e1c-be03-2eabddb7831d&amp;_gl=1*1t4sctk*_gcl_au*NTc5NTQ2MTg5LjE3NzE4ODMwMTA.*_ga*NTY0ODE0ODU0LjE3NDg0NDUwNDI.*_ga_XQJPQWHZHH*czE3NzkzODUwNzkkbzM4NiRnMCR0MTc3OTM4NTA4NCRqNTUkbDAkaDA.*_ga_TPGKGE8GTG*czE3NzkzODUwNzkkbzE4MCRnMCR0MTc3OTM4NTA4NCRqNTUkbDAkaDA.\" rel=\"nofollow noopener\" target=\"_blank\">3DEXPERIENCE Knowledge Base<\/a> or generated on your own.<\/p>\n<h4>Example Reports<\/h4>\n<p>The report examples consist of nine reports, including finding documents in a specific workflow state, with a specified configuration, and even referenced by another document.<\/p>\n<div id=\"attachment_76009\" style=\"width: 479px\" class=\"wp-caption aligncenter\"><img decoding=\"async\" aria-describedby=\"caption-attachment-76009\" class=\"wp-image-76009 size-full lazyload\" src=\"data:image\/gif;base64,R0lGODlhAQABAIAAAAAAAP\/\/\/yH5BAEAAAAALAAAAAABAAEAAAIBRAA7\" data-src=\"https:\/\/www.javelin-tech.com\/blog\/wp-content\/uploads\/2026\/05\/Image005.jpg\" alt=\"Report queries from the default file\" width=\"469\" height=\"272\" title=\"\"><p id=\"caption-attachment-76009\" class=\"wp-caption-text\"><noscript><img decoding=\"async\" class=\"wp-image-76009 size-full lazyload\" src=\"https:\/\/www.javelin-tech.com\/blog\/wp-content\/uploads\/2026\/05\/Image005.jpg\" alt=\"Report queries from the default file\" width=\"469\" height=\"272\" title=\"\"><\/noscript> Report queries from the default file<\/p><\/div>\n<p>These examples are extremely helpful for learning the Report Generator workflow and to reverse engineer your own custom query.<\/p>\n<h2>Assigning Report Permissions<\/h2>\n<p>When importing a report, you will be prompted to choose which users and groups have permissions to use that query. You can also add or remove rights for these queries to modify who is allowed to see and run them.<\/p>\n<div id=\"attachment_76008\" style=\"width: 610px\" class=\"wp-caption aligncenter\"><img decoding=\"async\" aria-describedby=\"caption-attachment-76008\" class=\"wp-image-76008 size-medium lazyload\" src=\"data:image\/gif;base64,R0lGODlhAQABAIAAAAAAAP\/\/\/yH5BAEAAAAALAAAAAABAAEAAAIBRAA7\" data-src=\"https:\/\/www.javelin-tech.com\/blog\/wp-content\/uploads\/2026\/05\/Image006-600x293.jpg\" alt=\"Editing report user permissions\" width=\"600\" height=\"293\" title=\"\"><p id=\"caption-attachment-76008\" class=\"wp-caption-text\"><noscript><img decoding=\"async\" class=\"wp-image-76008 size-medium lazyload\" src=\"https:\/\/www.javelin-tech.com\/blog\/wp-content\/uploads\/2026\/05\/Image006-600x293.jpg\" alt=\"Editing report user permissions\" width=\"600\" height=\"293\" title=\"\" srcset=\"https:\/\/www.javelin-tech.com\/blog\/wp-content\/uploads\/2026\/05\/Image006-600x293.jpg 600w, https:\/\/www.javelin-tech.com\/blog\/wp-content\/uploads\/2026\/05\/Image006.jpg 604w\" sizes=\"(max-width: 600px) 100vw, 600px\" \/><\/noscript> Editing report user permissions<\/p><\/div>\n<h2>Running Reports<\/h2>\n<p>Once the reports have been imported, they can be run on your vaults. Use the drop-down menu to select the vault you want to run the query on, then select the report you wish to run and click Run.<\/p>\n<div id=\"attachment_76007\" style=\"width: 610px\" class=\"wp-caption aligncenter\"><img decoding=\"async\" aria-describedby=\"caption-attachment-76007\" class=\"wp-image-76007 size-medium lazyload\" src=\"data:image\/gif;base64,R0lGODlhAQABAIAAAAAAAP\/\/\/yH5BAEAAAAALAAAAAABAAEAAAIBRAA7\" data-src=\"https:\/\/www.javelin-tech.com\/blog\/wp-content\/uploads\/2026\/05\/Image007-600x423.jpg\" alt=\"Example of a fully run query\" width=\"600\" height=\"423\" title=\"\"><p id=\"caption-attachment-76007\" class=\"wp-caption-text\"><noscript><img decoding=\"async\" class=\"wp-image-76007 size-medium lazyload\" src=\"https:\/\/www.javelin-tech.com\/blog\/wp-content\/uploads\/2026\/05\/Image007-600x423.jpg\" alt=\"Example of a fully run query\" width=\"600\" height=\"423\" title=\"\" srcset=\"https:\/\/www.javelin-tech.com\/blog\/wp-content\/uploads\/2026\/05\/Image007-600x423.jpg 600w, https:\/\/www.javelin-tech.com\/blog\/wp-content\/uploads\/2026\/05\/Image007-768x542.jpg 768w, https:\/\/www.javelin-tech.com\/blog\/wp-content\/uploads\/2026\/05\/Image007.jpg 1057w\" sizes=\"(max-width: 600px) 100vw, 600px\" \/><\/noscript> Example of a fully run query<\/p><\/div>\n<p>A fully run query will provide valuable report information that can be used to understand, organize, and manage files in a more streamlined manner.<\/p>\n<h2>Extending SOLIDWORKS PDM Automation<\/h2>\n<p>SOLIDWORKS PDM comes with a few helpful example queries to help you understand how the Report Generator works. To take this to the next level, you need to create custom queries to extract the information you need from your vault.<\/p>\n<p>For self-guided learning, consult the <a href=\"https:\/\/help.solidworks.com\/2026\/english\/EnterprisePDM\/admin\/c_EPDM_reports.htm?id=2.2.8\" rel=\"nofollow noopener\" target=\"_blank\">SOLIDWORKS PDM Help<\/a> documentation for information on creating custom reports. However, to leverage our services team to write the queries for you.<\/p>\n<p style=\"text-align: center;\"><strong><a href=\"https:\/\/www.javelin-tech.com\/3d\/people\/contact-sales\/\">To schedule a call to discuss your reporting needs, contact us here.<\/a><\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>The Report Generator in SOLIDWORKS PDM Professional\u00a0enables you to query and display information stored in the database server. However, this remains a largely unknown feature to even the most experienced administrators and users. Accessing the Report Generator in SOLIDWORKS PDM Professional will take you further into harnessing the full capability of SOLIDWORKS PDM. What is&hellip;<\/p>\n","protected":false},"author":316,"featured_media":76007,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[54,41],"tags":[19649,2137,9574],"class_list":["post-75990","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tech-tips","category-solidworks-pdm","tag-local-vault-view","tag-solidworks-pdm-administration","tag-solidworks-pdm-report"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.javelin-tech.com\/blog\/wp-json\/wp\/v2\/posts\/75990","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.javelin-tech.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.javelin-tech.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.javelin-tech.com\/blog\/wp-json\/wp\/v2\/users\/316"}],"replies":[{"embeddable":true,"href":"https:\/\/www.javelin-tech.com\/blog\/wp-json\/wp\/v2\/comments?post=75990"}],"version-history":[{"count":5,"href":"https:\/\/www.javelin-tech.com\/blog\/wp-json\/wp\/v2\/posts\/75990\/revisions"}],"predecessor-version":[{"id":77729,"href":"https:\/\/www.javelin-tech.com\/blog\/wp-json\/wp\/v2\/posts\/75990\/revisions\/77729"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.javelin-tech.com\/blog\/wp-json\/wp\/v2\/media\/76007"}],"wp:attachment":[{"href":"https:\/\/www.javelin-tech.com\/blog\/wp-json\/wp\/v2\/media?parent=75990"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.javelin-tech.com\/blog\/wp-json\/wp\/v2\/categories?post=75990"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.javelin-tech.com\/blog\/wp-json\/wp\/v2\/tags?post=75990"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}