{"id":60931,"date":"2026-07-10T08:00:50","date_gmt":"2026-07-10T12:00:50","guid":{"rendered":"https:\/\/www.javelin-tech.com\/blog\/?p=60931"},"modified":"2026-06-25T10:50:58","modified_gmt":"2026-06-25T14:50:58","slug":"how-to-filter-reports-in-solidworks-electrical","status":"publish","type":"post","link":"https:\/\/www.javelin-tech.com\/blog\/2026\/07\/how-to-filter-reports-in-solidworks-electrical\/","title":{"rendered":"How to Filter Reports in SOLIDWORKS Electrical"},"content":{"rendered":"<p>Arguably, the most effective skill for managing electrical projects is knowing how to filter reports in SOLIDWORKS Electrical.<\/p>\n<p>Learning to filter reports in <a href=\"https:\/\/www.javelin-tech.com\/3d\/technology\/solidworks-electrical\/\">SOLIDWORKS Electrical<\/a>, specifically by book, is an effective tool to manage electrical projects and reports. Filtering reports will provide streamlined data and organization.<\/p>\n<h2>Why Filter Reports in SOLIDWORKS Electrical?<\/h2>\n<p>Managing bills of materials and generating accurate reports are essential parts of any SOLIDWORKS Electrical project. As projects grow in size and complexity, especially those containing multiple document books, organizing and filtering reports becomes increasingly challenging. When you need to isolate information by book, such as separating BOMs, wire lists, or component reports, manually sorting through pages of data can quickly become overwhelming.<\/p>\n<p>Fortunately, SOLIDWORKS Electrical provides a clean and efficient way to filter reports by book without modifying SQL queries or writing custom code. The key is to assign each document book to a location, then filter your reports based on that location. This method keeps your workflow simple, organized, and fully within the standard interface.<\/p>\n<h2>Getting Started with Report Filtering<\/h2>\n<p>The process for filtering reports in SOLIDWORKS Electrical by book can be split into three steps:<\/p>\n<ol>\n<li>Assigning document book locations<\/li>\n<li>Filtering by location<\/li>\n<li>Generating the reports<\/li>\n<\/ol>\n<h4>Assign Document Books to Locations<\/h4>\n<p>Before you can filter reports by book, you must first assign each document book to a unique location. This creates a clear organizational structure that SOLIDWORKS Electrical can reference when generating filtered reports.<\/p>\n<p><strong>To assign a document book to a location:<\/strong><\/p>\n<ol start=\"1\">\n<li>Right-click the document book in your project tree.<\/li>\n<li>Select Properties.<\/li>\n<li>In the Properties window, find the Location field.<\/li>\n<li>Click the three dots next to the location field to open the location selection window.<\/li>\n<\/ol>\n<div id=\"attachment_60932\" style=\"width: 610px\" class=\"wp-caption aligncenter\"><img decoding=\"async\" aria-describedby=\"caption-attachment-60932\" class=\"wp-image-60932 size-medium lazyload\" src=\"data:image\/gif;base64,R0lGODlhAQABAIAAAAAAAP\/\/\/yH5BAEAAAAALAAAAAABAAEAAAIBRAA7\" data-src=\"https:\/\/www.javelin-tech.com\/blog\/wp-content\/uploads\/2024\/01\/1-600x356.png\" alt=\"Viewing the location of a SOLIDWORKS Electrical book\" width=\"600\" height=\"356\" title=\"\"><p id=\"caption-attachment-60932\" class=\"wp-caption-text\"><noscript><img decoding=\"async\" class=\"wp-image-60932 size-medium lazyload\" src=\"https:\/\/www.javelin-tech.com\/blog\/wp-content\/uploads\/2024\/01\/1-600x356.png\" alt=\"Viewing the location of a SOLIDWORKS Electrical book\" width=\"600\" height=\"356\" title=\"\" srcset=\"https:\/\/www.javelin-tech.com\/blog\/wp-content\/uploads\/2024\/01\/1-600x356.png 600w, https:\/\/www.javelin-tech.com\/blog\/wp-content\/uploads\/2024\/01\/1-1220x724.png 1220w, https:\/\/www.javelin-tech.com\/blog\/wp-content\/uploads\/2024\/01\/1-768x456.png 768w, https:\/\/www.javelin-tech.com\/blog\/wp-content\/uploads\/2024\/01\/1-1536x912.png 1536w, https:\/\/www.javelin-tech.com\/blog\/wp-content\/uploads\/2024\/01\/1.png 1919w\" sizes=\"(max-width: 600px) 100vw, 600px\" \/><\/noscript> Viewing the location of a SOLIDWORKS Electrical book<\/p><\/div>\n<p>A list of existing locations will appear. If the location you need is not listed, you can easily create a new one.<\/p>\n<p><strong>To create a new location in SOLIDWORKS Electrical:<\/strong><\/p>\n<ol>\n<li>Click New Location in the upper left corner of the window.<\/li>\n<li>Name the location appropriately.<\/li>\n<li>Select the new location in the left panel<\/li>\n<li>Click select to assign it to the document book.<\/li>\n<\/ol>\n<div id=\"attachment_60933\" style=\"width: 610px\" class=\"wp-caption aligncenter\"><img decoding=\"async\" aria-describedby=\"caption-attachment-60933\" class=\"wp-image-60933 size-medium lazyload\" src=\"data:image\/gif;base64,R0lGODlhAQABAIAAAAAAAP\/\/\/yH5BAEAAAAALAAAAAABAAEAAAIBRAA7\" data-src=\"https:\/\/www.javelin-tech.com\/blog\/wp-content\/uploads\/2024\/01\/2-600x356.png\" alt=\"Assigning a new location\" width=\"600\" height=\"356\" title=\"\"><p id=\"caption-attachment-60933\" class=\"wp-caption-text\"><noscript><img decoding=\"async\" class=\"wp-image-60933 size-medium lazyload\" src=\"https:\/\/www.javelin-tech.com\/blog\/wp-content\/uploads\/2024\/01\/2-600x356.png\" alt=\"Assigning a new location\" width=\"600\" height=\"356\" title=\"\" srcset=\"https:\/\/www.javelin-tech.com\/blog\/wp-content\/uploads\/2024\/01\/2-600x356.png 600w, https:\/\/www.javelin-tech.com\/blog\/wp-content\/uploads\/2024\/01\/2-1220x724.png 1220w, https:\/\/www.javelin-tech.com\/blog\/wp-content\/uploads\/2024\/01\/2-768x456.png 768w, https:\/\/www.javelin-tech.com\/blog\/wp-content\/uploads\/2024\/01\/2-1536x912.png 1536w, https:\/\/www.javelin-tech.com\/blog\/wp-content\/uploads\/2024\/01\/2.png 1919w\" sizes=\"(max-width: 600px) 100vw, 600px\" \/><\/noscript> Assigning a new location<\/p><\/div>\n<p>Repeat this process for each document book in your project. If your goal is to filter reports by book, ensure that each book is assigned to a different location.<\/p>\n<h4>Filter Reports by Location<\/h4>\n<p>Once your document books are assigned to locations, the next step is to apply filters to your reports.<\/p>\n<p><strong>To apply a filter to the report:<\/strong><\/p>\n<ol start=\"1\">\n<li>Go to the Project tab and select Reports to open the Report Manager<\/li>\n<li>Choose the report you want to filter (e.g., BOM, wire list, component list)<\/li>\n<li>Click Properties.<\/li>\n<li>Navigate to the Filters tab.<\/li>\n<li>Click Add Filter.<\/li>\n<\/ol>\n<div id=\"attachment_60938\" style=\"width: 610px\" class=\"wp-caption aligncenter\"><img decoding=\"async\" aria-describedby=\"caption-attachment-60938\" class=\"wp-image-60938 size-medium lazyload\" src=\"data:image\/gif;base64,R0lGODlhAQABAIAAAAAAAP\/\/\/yH5BAEAAAAALAAAAAABAAEAAAIBRAA7\" data-src=\"https:\/\/www.javelin-tech.com\/blog\/wp-content\/uploads\/2024\/01\/3-600x422.png\" alt=\"Filtering reports in SOLIDWORKS Electrical\" width=\"600\" height=\"422\" title=\"\"><p id=\"caption-attachment-60938\" class=\"wp-caption-text\"><noscript><img decoding=\"async\" class=\"wp-image-60938 size-medium lazyload\" src=\"https:\/\/www.javelin-tech.com\/blog\/wp-content\/uploads\/2024\/01\/3-600x422.png\" alt=\"Filtering reports in SOLIDWORKS Electrical\" width=\"600\" height=\"422\" title=\"\" srcset=\"https:\/\/www.javelin-tech.com\/blog\/wp-content\/uploads\/2024\/01\/3-600x422.png 600w, https:\/\/www.javelin-tech.com\/blog\/wp-content\/uploads\/2024\/01\/3-1220x859.png 1220w, https:\/\/www.javelin-tech.com\/blog\/wp-content\/uploads\/2024\/01\/3-768x541.png 768w, https:\/\/www.javelin-tech.com\/blog\/wp-content\/uploads\/2024\/01\/3.png 1280w\" sizes=\"(max-width: 600px) 100vw, 600px\" \/><\/noscript> Filtering reports in SOLIDWORKS Electrical<\/p><\/div>\n<p>A filter window will appear. This is where you define the condition that limits the report to a specific location. To filter by location, use the loc_text field and specify the value, or name, for the location.<\/p>\n<div id=\"attachment_60937\" style=\"width: 610px\" class=\"wp-caption aligncenter\"><img decoding=\"async\" aria-describedby=\"caption-attachment-60937\" class=\"wp-image-60937 size-medium lazyload\" src=\"data:image\/gif;base64,R0lGODlhAQABAIAAAAAAAP\/\/\/yH5BAEAAAAALAAAAAABAAEAAAIBRAA7\" data-src=\"https:\/\/www.javelin-tech.com\/blog\/wp-content\/uploads\/2024\/01\/4-600x354.png\" alt=\"Defining the location filter\" width=\"600\" height=\"354\" title=\"\"><p id=\"caption-attachment-60937\" class=\"wp-caption-text\"><noscript><img decoding=\"async\" class=\"wp-image-60937 size-medium lazyload\" src=\"https:\/\/www.javelin-tech.com\/blog\/wp-content\/uploads\/2024\/01\/4-600x354.png\" alt=\"Defining the location filter\" width=\"600\" height=\"354\" title=\"\" srcset=\"https:\/\/www.javelin-tech.com\/blog\/wp-content\/uploads\/2024\/01\/4-600x354.png 600w, https:\/\/www.javelin-tech.com\/blog\/wp-content\/uploads\/2024\/01\/4-1220x720.png 1220w, https:\/\/www.javelin-tech.com\/blog\/wp-content\/uploads\/2024\/01\/4-768x453.png 768w, https:\/\/www.javelin-tech.com\/blog\/wp-content\/uploads\/2024\/01\/4.png 1263w\" sizes=\"(max-width: 600px) 100vw, 600px\" \/><\/noscript> Defining the location filter<\/p><\/div>\n<p>You will now see the new filter listed in the Filters tab. Repeat this process for each location or document book you want to filter individually. In many cases, you may only need two or three filters, but larger projects may require more.<\/p>\n<h4>Generating the Reports<\/h4>\n<p>With your filters created, the last step is to generate reports showing only the information you desire.<\/p>\n<p><strong>To generate reports by book:<\/strong><\/p>\n<ol start=\"1\">\n<li>In the Report Manager, locate the Filter description drop\u2011down menu for your report.<\/li>\n<li>Select the filter corresponding to the location (book) you want to generate.\n<p><div id=\"attachment_60935\" style=\"width: 610px\" class=\"wp-caption aligncenter\"><img decoding=\"async\" aria-describedby=\"caption-attachment-60935\" class=\"wp-image-60935 size-medium lazyload\" src=\"data:image\/gif;base64,R0lGODlhAQABAIAAAAAAAP\/\/\/yH5BAEAAAAALAAAAAABAAEAAAIBRAA7\" data-src=\"https:\/\/www.javelin-tech.com\/blog\/wp-content\/uploads\/2024\/01\/6-600x356.png\" alt=\"Using the location filter dropdown\" width=\"600\" height=\"356\" title=\"\"><p id=\"caption-attachment-60935\" class=\"wp-caption-text\"><noscript><img decoding=\"async\" class=\"wp-image-60935 size-medium lazyload\" src=\"https:\/\/www.javelin-tech.com\/blog\/wp-content\/uploads\/2024\/01\/6-600x356.png\" alt=\"Using the location filter dropdown\" width=\"600\" height=\"356\" title=\"\" srcset=\"https:\/\/www.javelin-tech.com\/blog\/wp-content\/uploads\/2024\/01\/6-600x356.png 600w, https:\/\/www.javelin-tech.com\/blog\/wp-content\/uploads\/2024\/01\/6-1220x724.png 1220w, https:\/\/www.javelin-tech.com\/blog\/wp-content\/uploads\/2024\/01\/6-768x456.png 768w, https:\/\/www.javelin-tech.com\/blog\/wp-content\/uploads\/2024\/01\/6-1536x912.png 1536w, https:\/\/www.javelin-tech.com\/blog\/wp-content\/uploads\/2024\/01\/6.png 1816w\" sizes=\"(max-width: 600px) 100vw, 600px\" \/><\/noscript> Using the location filter dropdown<\/p><\/div><\/li>\n<li>Select Generate drawings.<\/li>\n<\/ol>\n<p>SOLIDWORKS Electrical will now produce a report containing only the data associated with that specific document book. By assigning document books to locations and filtering reports based on those locations, you can keep your data organized, accessible, and easy to manage.<\/p>\n<h2>Expanding SOLIDWORKS Electrical Capabilities<\/h2>\n<p>SOLIDWORKS Electrical simplifies electrical schematics, making the design of electrical systems more efficient by doing more than just report filtering. With SOLIDWORKS Electrical, you can create templates or automate additional reporting tasks to reduce mistakes, increase efficiency, and save money.<\/p>\n<p style=\"text-align: center;\"><strong><a href=\"https:\/\/www.javelin-tech.com\/3d\/technology\/quote\/?Product=SOLIDWORKS%20Electrical\">To learn more about implementing SOLIDWORKS Electrical to streamline electro-mechanical design, contact our team here.<\/a><\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Arguably, the most effective skill for managing electrical projects is knowing how to filter reports in SOLIDWORKS Electrical. Learning to filter reports in SOLIDWORKS Electrical, specifically by book, is an effective tool to manage electrical projects and reports. Filtering reports will provide streamlined data and organization. Why Filter Reports in SOLIDWORKS Electrical? Managing bills of&hellip;<\/p>\n","protected":false},"author":287,"featured_media":60935,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[192,54],"tags":[1527,654,7172],"class_list":["post-60931","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-solidworks-electrical","category-tech-tips","tag-microsoft-sql","tag-reporting","tag-solidworks-electrical-schematic"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.javelin-tech.com\/blog\/wp-json\/wp\/v2\/posts\/60931","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\/287"}],"replies":[{"embeddable":true,"href":"https:\/\/www.javelin-tech.com\/blog\/wp-json\/wp\/v2\/comments?post=60931"}],"version-history":[{"count":4,"href":"https:\/\/www.javelin-tech.com\/blog\/wp-json\/wp\/v2\/posts\/60931\/revisions"}],"predecessor-version":[{"id":77444,"href":"https:\/\/www.javelin-tech.com\/blog\/wp-json\/wp\/v2\/posts\/60931\/revisions\/77444"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.javelin-tech.com\/blog\/wp-json\/wp\/v2\/media\/60935"}],"wp:attachment":[{"href":"https:\/\/www.javelin-tech.com\/blog\/wp-json\/wp\/v2\/media?parent=60931"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.javelin-tech.com\/blog\/wp-json\/wp\/v2\/categories?post=60931"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.javelin-tech.com\/blog\/wp-json\/wp\/v2\/tags?post=60931"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}