Many SYSPRO customers think of me as \u2018the report guy\u2019. Odd as it may seem, I\u2019ve always loved writing reports. I also enjoy helping SYSPRO users learn to write better reports. Over the course of many years I\u2019ve realized that there are six main points that should be considered when writing reports that are both informative and easy to digest.<\/p>\n
Before we tuck into a meal we \u2018eat it with our eyes\u2019. The same is true of reports. A good report writer, like a good chef, is alive to the nuances of presentation. Proper spacing, plenty of white space, a readable font and informative headers provide a professional polish that readers find pleasing.<\/p>\n
Many busy executives head straight for the opening summary \u2013 information presented in a condensed version. Make sure that your summary is highly visible and unabashedly concise. When possible, stick to percentages, which are more easily understood and compared than the same information written in text.<\/p>\n
How your report will be viewed also depends on the landscape it\u2019s seen on. It might look great on your desktop in Excel, but will it translate seamlessly to other platforms? Don\u2019t hit \u2018send\u2019 until you\u2019ve checked! All your hard work could be wasted once you distribute it online, within your ERP application, in an email, or to a mobile device. Check your report in full screen view \u2013 can all the columns be seen? And what happens if you hit the \u2018print\u2019 button? Does it faithfully produce the document? Does that include the full-screen view?<\/p>\n
The information in a report needs to be easily absorbed. How the sort option is applied is probably as important as the header titles which describe the information contained in the report. If possible, give as many views to the report as possible, e.g., per day\/per week\/per month\/year-to-date\/all information. When it comes to sorting, it\u2019s best to anticipate your audience\u2019s needs.<\/p>\n
Would the information in your report be of interest to the competition? You should always consider who needs, and who doesn\u2019t need, to see any given report. For sensitive information, an extra layer of security can be added by locking the report with a password, or by using SYSPRO\u2019s assigned-role security. (If you\u2019re not familiar with the power of assigned roles, and assigned role security, please read Alistair\u2019s blog).<\/p>\n
I am going to say this out loud \u2013 graphs and charts are sexy! Furthermore, graphical imagery is easily compiled and readily understood. A pedestrian listing of numbers in columns is dry, and (for many people) difficult to follow. Creating charts and graphs will make you feel and look good. Your end users will thank you for presenting the information in a manner that allows them to grasp it at a glance.<\/p>\n
When a report takes a long time to compile it is best to schedule it overnight. Simple reports can be compiled quickly, but complex reports can take a long time, especially if they are pulling in data from many tables that need to be validated. The validation process eats up a lot of time, compounded by multiple calls to the same tables with different sorting criteria, and variables thrown in to the same table over and over again. When speed is of the essence a simplified report is generally best, with drill down features available.<\/p>\n
A drill through report allows you to go from summary to detail, often by jumping to another report, or even by linking to a relevant URL. For instance: a financial application shows the balance and profit and loss for a specific time frame. Every general ledger displays the total amount of all transactions for this specific period. By clicking (drill through) on one of the general ledgers you will see the underlying transactions for this specific period.<\/p>\n
A drill down report allows you to view data at different levels of detail. For instance, a report displays information on the Country level. If we drill down the report displays information on the State level. The next drill down will display information on the City level. Each level of detail is sequentially available through drill down. Likewise, \u2018Year\u2019 contains \u2018Months\u2019, which contain \u2018Weeks\u2019, which contains \u2018Days\u2019, which contains Hours, which contains “Minutes”.<\/p>\n
The practical aspects of my report-writing philosophy are based on a handful of general observations that I\u2019ve come to hold as essential:<\/p>\n