![\"Crystal](\"https:\/\/blog-assets.solidworks.com\/uploads\/sites\/17\/Reports-1-300x164.png\")
Crystal Reports Writer is a report writing program I\u2019m very familiar with. It\u2019s easy to use, and the savvy report writer has a lot of tools at their disposal while the rookie Crystal Report writer can write simple reports in a matter of minutes.<\/p>\n
Good report writing adds value to the success of a company. If data isn\u2019t extracted and presented in an easy-to-read manner, it\u2019s not worth any more than the data itself.<\/p>\n
As a report writer, you have to know who your audience will be, exactly what data needs to be displayed, where is it stored and how much data and detail to present to the user.<\/p>\n
I have been writing and troubleshooting reports written by IQMS ERP<\/a>\u00a0users for many years and I\u2019d like to take this opportunity to save the rookie writer some time and headaches.<\/p>\n Here a few Crystal Report Writer tips<\/strong> to keep in mind as you begin writing reports (the last one is for IQMS ERP users only and it\u2019s my current favorite):<\/p>\n If you are writing a report against a single database (for example, if you use IQMS ERP, a fully integrated manufacturing ERP software<\/a>), then set up your data explorer to only use tables and views owned by the database you are querying. If you are an IQMS ERP user, for example, then set the \u2018Owner LIKE\u2019 field to IQMS. That way you won\u2019t have to sort through all of the other data sources that aren\u2019t relevant.<\/p>\n The report will look correct when you write it and run it, but if you forget to turn off this option, you will hear about it later from the user when they don\u2019t receive \u201cnew\u201d data each time they run the report.<\/p>\n In this case, it\u2019s OK to plagiarize. IQMS offers thousands of reports in its report catalog. If you are an IQMS ERP user, run a few reports in the software. If you see a report that appears to display similar data or in the same format that you are thinking about, then open the report and dissect it. Everybody who writes reports will tell you they have done this before.<\/p>\n How you join or link datasets (tables or views) can make or break your report. Always use a left outer join to ensure you aren\u2019t inadvertently excluding data from a report.<\/p>\n For example, if you are writing a report against the IQMS ERP database about a Corrective Action Request (CAR)<\/a>, you would start with the CAR table. If you then want to list the elements of each CAR, you would bring in and join the CAR_Element table to the right of the CAR table.<\/p>\n Even if one of the CARs doesn\u2019t currently have elements attached and you would still like to view those CARs, if you use an equal join, you are limiting the data to just CARs with elements listed.<\/p>\n Instead, use a left outer join and set up a parameter to let the user decide if they want to view all CARs or not. Otherwise, you will be troubleshooting this report later.<\/p>\n Every once in awhile, a software feature that seems so simple makes your life so much easier that you won\u2019t know how you worked without it. IQMS offers direct access to reports from the ERP software<\/a>.<\/p>\n Open any reports menu, click on Report Editor and (if you have Crystal Report installed) the report opens in Crystal Reports, ready for editing. Brilliant, right?! No more figuring out the filename, opening Crystal Reports and waiting to select the file. It saves a lot of time!<\/p>\n Are there any other report writing tips for the rookie writer that I didn\u2019t mention? I would be interested to hear what other tricks you know of that make daily report writing easier.<\/p>\n To learn more about how IQMS provides strong choices to fit the needs and interests of manufacturers everywhere, click www.iqms.com<\/a>.<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":" Crystal Reports Writer is a report writing program I\u2019m very familiar with. It\u2019s easy to use, and the savvy report writer has a lot of tools at their disposal while the rookie Crystal Report writer can write simple reports in<\/p>\n... Continued<\/a>","protected":false},"author":553,"featured_media":2736,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[25,29,1],"tags":[121],"class_list":["post-2735","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-all-posts","category-erp-technology-and-automation","category-uncategorized","tag-financereporting"],"acf":[],"_links":{"self":[{"href":"https:\/\/blogs.solidworks.com\/delmiaworks\/wp-json\/wp\/v2\/posts\/2735","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.solidworks.com\/delmiaworks\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blogs.solidworks.com\/delmiaworks\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.solidworks.com\/delmiaworks\/wp-json\/wp\/v2\/users\/553"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.solidworks.com\/delmiaworks\/wp-json\/wp\/v2\/comments?post=2735"}],"version-history":[{"count":1,"href":"https:\/\/blogs.solidworks.com\/delmiaworks\/wp-json\/wp\/v2\/posts\/2735\/revisions"}],"predecessor-version":[{"id":2753,"href":"https:\/\/blogs.solidworks.com\/delmiaworks\/wp-json\/wp\/v2\/posts\/2735\/revisions\/2753"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blogs.solidworks.com\/delmiaworks\/wp-json\/wp\/v2\/media\/2736"}],"wp:attachment":[{"href":"https:\/\/blogs.solidworks.com\/delmiaworks\/wp-json\/wp\/v2\/media?parent=2735"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blogs.solidworks.com\/delmiaworks\/wp-json\/wp\/v2\/categories?post=2735"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blogs.solidworks.com\/delmiaworks\/wp-json\/wp\/v2\/tags?post=2735"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}5 Crystal Reports Writer Tips<\/h2>\n
#1. Use correct tables and views<\/h3>\n
#2. Turn off \u2018Save data with report<\/h3>\n
#3. Plagiarize from other reports<\/h3>\n
#4. Join and link datasets correctly<\/h3>\n
#5. Save time with IQMS ERP<\/h3>\n