Reporting

 

Introduction

 
Reporting in SysAid is a tricky art, not easily mastered, it certainly took me a while, but here to help you along is a summary of some good threads on the topic:

Report customization is only possible in SysAid full edition with the manager portal.
Reports customization requires some programming skills and you can find most the needed information on how to do it in the manager portal guide which can be found at:http://ilient.com/down/manager_portal.pdf 

Ilient can also customize the report for you as a custom development project.
For more information, please contact helpdesk@ilient.com with your request and they will provide you with all the information on this option.


Common Questions

 
Which version of JasperReport/ireports to use - http://www.ilient.com/Sysforums/posts/list/426.page 
Using logical conditions in your select statement within ireports and SysAid reporting - http://www.ilient.com/Sysforums/posts/list/1819.page 
What does the union field mean in the "workload by administrator" report - http://www.ilient.com/Sysforums/posts/list/2048.page
How to extract the inventory_xml data - http://www.ilient.com/Sysforums/posts/list/0/2072.page
 

Known Issues

 
Report Fix: "Categories with the most SR's" - http://www.ilient.com/Sysforums/posts/list/1279.page
Report fix: Software/Hardware inventory duplicate listing fix - http://www.ilient.com/Sysforums/posts/list/1219.page
Problem with angle brackets being interpreted as html tags - http://www.ilient.com/Sysforums/posts/list/989.page 
If you want to use the Service Breach Report based on due dates you are going to need to follow the modifications here - http://www.ilient.com/Sysforums/posts/list/509.page because it is based on timers
Satisfaction by category report average is wrong - Fixed in v
5.6 +

Feature Requests

Scheduling Publishing of Reports - http://www.ilient.com/Sysforums/posts/list/1142.page#4947 (Not scheduled emailing of reports which it can already do)
Change "Days" in Service Quality Reports to "Hours" - http://www.ilient.com/Sysforums/posts/list/688.page#2935 


 Report Samples
 
From Haim:

Adding your own company logo to SysAid's reports - http://www.ilient.com/Sysforums/posts/list/1226.page
Removing the windows hotfixs from the "asset changes" report - http://www.ilient.com/Sysforums/posts/list/1227.page 
Creating a basic report "service request list" - http://www.ilient.com/Sysforums/posts/list/1228.page 
Changing the reports page size - http://www.ilient.com/Sysforums/posts/list/1229.page 
Add grouping by admin group to the "Service Quality By Timer" report - http://www.ilient.com/Sysforums/posts/list/1230.page 
Running the "activities by administrator" report for all administrators at the same time - http://www.ilient.com/Sysforums/posts/list/1231.page 
Create a report "Opened/Closed Requests Per Department" - http://www.ilient.com/Sysforums/posts/list/1232.page 

From Techguy:

Active Requests report - Group Selection by Status - http://www.ilient.com/Sysforums/posts/list/413.page#1530 
Service Requests Opened by Administrator - http://www.ilient.com/Sysforums/posts/list/362.page 
Report: Active requests vs Date - ( I did not get round to finishing this report -maybe one of you will) - http://www.ilient.com/Sysforums/posts/list/220.page
Modify Activities by User report to report on one of the custom fields - http://www.ilient.com/Sysforums/posts/list/806.page 
Asset Details without Software - http://www.ilient.com/Sysforums/posts/list/1569.page 
Due Date Changes Report - http://www.ilient.com/Sysforums/posts/list/1419.page 

Debugging Tips
 
When trying to debug reports you need to look at the sysaid.log file to find the real errors.

 2008-11-03 13:17:30,959 [Thread-5] ERROR com.ilient - Exception while trying to compile report codeorg.xml.sax.SAXParseException: The content of elements must consist of well-formed character data or markup. This is related to the bug with the angle brackets being interpreted as html (see known issues above for the answer) http://www.ilient.com/Sysforums/posts/list/989.page 
net.sf.jasperreports.engine.JRException: Attribute value "Your Report Name" of type NMTOKEN must be a name token. When creating a report Jasper Reports do not put spaces in the report name. TO fix this just remove the spaces in the jrxml file. 
 
Comments