{"id":18417,"date":"2017-11-10T11:00:23","date_gmt":"2017-11-10T16:00:23","guid":{"rendered":"https:\/\/blogs.solidworks.com\/tech\/?p=18417"},"modified":"2017-11-06T14:54:03","modified_gmt":"2017-11-06T19:54:03","slug":"solidworks-electrical-customizing-simple-reports-part-1","status":"publish","type":"post","link":"https:\/\/blogs.solidworks.com\/tech\/2017\/11\/solidworks-electrical-customizing-simple-reports-part-1.html","title":{"rendered":"SOLIDWORKS Electrical: Customizing Simple Reports – Part 1"},"content":{"rendered":"

As you may already know SOLIDWORKS Electrical uses a SQL database to contain and maintain all our Electrical data and information. This has many benefits speed, resilience, multiuser working to name a few but one of the primary features is that the database can be interrogated to present the information it holds and present it how you want to see it.<\/p>\n

By now I am sure you have explored the many reports that ship as standard with Electrical, if not these can be found in the report manager project\/reports\/add.<\/p>\n

\"SOLIDWORKS<\/p>\n

When you check out the list you may notice the report title either end in _Imperial or _Metric this is due to the reports being \u201cunit aware\u201d. So you may need to save a report twice to make it available for both unit systems<\/p>\n

If you can\u2019t find a report that meets your needs you will need to either customise an existing report or create your own.<\/p>\n

Go to Project\/Configurations\/Reports<\/strong><\/p>\n

Go down the list of reports and choose the report closest to your desired output highlight it and choose to make a copy<\/strong>.<\/p>\n

\"Project\/Configuration\/Reports\"<\/p>\n

Important: Only edit a report directly if you are sure you do not want to keep it. <\/strong><\/span><\/p>\n

\"\"<\/p>\n

You will be asked if you want to edit the new configuration say yes:<\/p>\n

\"Configuration\"<\/p>\n

The first thing you need to do is to rename a save the new report:<\/p>\n

\"Saving<\/p>\n

Ok we can now change how the report looks in drawings and what data is used.<\/p>\n

First let\u2019s choose the overall look of the report. Select the style tab and you can now choose the fonts for the title, header, content and the totals, remember we are working on an imperial report hence the text height is in inches e.g. 0.1\u201d<\/p>\n

\"Report<\/p>\n

You will, I am sure, notice that as you make changes the preview at the top of the screen updates to reflect the changes.<\/p>\n

We can now choose what data is to be displayed and how:<\/p>\n

\"Display\"<\/p>\n

When the SQL query was written by SOLIDWORKS they did not just include the basic information for the report, they thought of what other data a user may want to include and made that available as well. To include it in the report simply tick the selection box.<\/p>\n

It\u2019s simple to reorder the data by highlighting what you wish to move and using the arrows at the side to navigate.<\/p>\n

\"SQL<\/p>\n

We can do more formatting of the tables. I will cover this in part two of my blog.<\/p>\n

We can now adjust the layout of the report drawing.<\/p>\n

\"Report<\/p>\n

If you look at the preview my description field is now two wide so I am going to go back to the columns tab and change the description width from 10 to 5, remember don\u2019t forget to choose the apply button.<\/p>\n

\"Adjusting<\/p>\n

If you have applied the changes we will close the report editor and now open a project a test the report.<\/p>\n

In my next blog, I will discuss more about column formatting, how to sort the information and how to apply filters. In my final blog if I am feeling brave I will discuss what happens when you click the expert mode!<\/p>\n

By Simon Knibbs, SOLIDWORKS Electrical Specialist<\/h3>\n","protected":false},"excerpt":{"rendered":"

As you may already know SOLIDWORKS Electrical uses a SQL database to contain and maintain all our Electrical data and information. This has many benefits speed, resilience, multiuser working to name a few but one of the primary features is<\/p>\n... Continued<\/a>","protected":false},"author":202,"featured_media":18426,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[24,35,36],"tags":[1453,385,877,60,453],"class_list":["post-18417","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-solidworks-electrical","category-tips-tricks","category-usability","tag-reports","tag-solidworks-electrical-2","tag-sql","tag-tech-tip","tag-tips-and-tricks"],"acf":[],"_links":{"self":[{"href":"https:\/\/blogs.solidworks.com\/tech\/wp-json\/wp\/v2\/posts\/18417","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.solidworks.com\/tech\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blogs.solidworks.com\/tech\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.solidworks.com\/tech\/wp-json\/wp\/v2\/users\/202"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.solidworks.com\/tech\/wp-json\/wp\/v2\/comments?post=18417"}],"version-history":[{"count":3,"href":"https:\/\/blogs.solidworks.com\/tech\/wp-json\/wp\/v2\/posts\/18417\/revisions"}],"predecessor-version":[{"id":18628,"href":"https:\/\/blogs.solidworks.com\/tech\/wp-json\/wp\/v2\/posts\/18417\/revisions\/18628"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blogs.solidworks.com\/tech\/wp-json\/wp\/v2\/media\/18426"}],"wp:attachment":[{"href":"https:\/\/blogs.solidworks.com\/tech\/wp-json\/wp\/v2\/media?parent=18417"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blogs.solidworks.com\/tech\/wp-json\/wp\/v2\/categories?post=18417"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blogs.solidworks.com\/tech\/wp-json\/wp\/v2\/tags?post=18417"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}