http://www.sysaid.com/Sysforums/posts/list/118.page JForum - http://www.jforum.net
Our company needs a lot of customized reports which we cannot find in the SysAid Manager portal
or in the report builder built-in by sysaid itself.

And since we have our database running on SQL we started using Jasper iReports in combination with Jasper reporting Server
so we can use sql queries to create the desired reports and upload them on the jasper server to get a nice graphical overview/layout on the reports.
Through this way our management can also access the website and run the reports themselves.

Now I created the following report with Jasper iReports with the query below,
with this query we want to get the activities spent from a administrator within a certain period of time:

[code]SELECT
DateDiff(MINUTE,work_report.from_time,work_report.to_time) AS TotalMIN,
work_report."service_req_id",
company."company_name",
service_req."request_user",
service_req."problem_type" AS First_lvl_category,
service_req."problem_sub_type" AS second_lvl_category,
service_req."third_level_category",
service_req."title" AS second_lvl_category,
service_req."solution" AS second_lvl_category,
work_report."from_time" AS second_lvl_category,
work_report."to_time" AS second_lvl_category,
work_report."description" AS Activity_descr
FROM
"work_report" work_report INNER JOIN "service_req" service_req ON work_report."service_req_id" = service_req."id"
INNER JOIN "sysaid_user" sysaid_user ON service_req."request_user" = sysaid_user."user_name"
INNER JOIN "company" company ON sysaid_user."company" = company."company_id"
WHERE
work_report.from_time BETWEEN $P{StartDate} AND $P{EndDate}[/code]

[b]This is working fine within Jasper iReports but it is not working on the Jasper Server.
(within iReports we get a popup to select the date)[/b]

Does anybody else here has experience with SysAid SQL database in combination with Jasper iReports/Jasper server?
I saw some posts about it in the past but never something concrete.

ps: If someone is interested I can share the other working queries/reports we created so far.
]]> http://www.sysaid.com/Sysforums/posts/preList/8152/33624.page http://www.sysaid.com/Sysforums/posts/preList/8152/33624.page GMT
It may be a coincidence but we have the same issue with more or less the same query.
In our environment it is also working iReport but not in Jasper Server.
The report is shown without errors but also there are no records displayed and we are sure that they do exist.

Hopefully someone can help us but if you may find a solution for it please keep us updated as well.

Best regards,

Paauwtje]]> http://www.sysaid.com/Sysforums/posts/preList/8152/33625.page http://www.sysaid.com/Sysforums/posts/preList/8152/33625.page GMT You do not need to do this if you do the query in the script tab and just pass the data to the ireport for formatting (this is the way the native Sysaid reports work).]]> http://www.sysaid.com/Sysforums/posts/preList/8152/33642.page http://www.sysaid.com/Sysforums/posts/preList/8152/33642.page GMT
Thanks for your reply.
NWG-IT and I use Ireport or the server of it this application will connect to the correct database.
For me it is not the problem.
Other reports are working fine for me only this one isn't

Br,

Paauwtje]]> http://www.sysaid.com/Sysforums/posts/preList/8152/33643.page http://www.sysaid.com/Sysforums/posts/preList/8152/33643.page GMT
Yes indeed, all other reports I created are working fine on iReports and Jasper server.
But once adding the selection boxes from a certain date or an administrator selection then it does not work on the Jasper Server anymore,
while this specific report is working in iReports.]]> http://www.sysaid.com/Sysforums/posts/preList/8152/33644.page http://www.sysaid.com/Sysforums/posts/preList/8152/33644.page GMT if you are running them from SysAid then the SysAid log file will show details of any errors. If you are passing parameters to a selection box, you have to do it a certain way when launching them from SysAid, to See how to do this look at Haim's tutorial http://www.ilient.com/Sysforums/posts/list/1228.page
]]> http://www.sysaid.com/Sysforums/posts/preList/8152/33646.page http://www.sysaid.com/Sysforums/posts/preList/8152/33646.page GMT
I will try to explain how we do it:

1) we create the SQL query ourselves to get the desired report we would like to see

2) then I put the SQL query in iReports to add a graphical overview and fields on it
within Jesper iReports you can also add selection fields/boxes to pick a certain date or a certain administrator

3) Once it is working in iReports we move the report to our reporting server from JasperReports Server (jaspersoft)
http://www.jaspersoft.com/reporting-server
please check the link to get a view from how it looks

4) So all reports are working on iReports and JasperReports Server, BUT when we add a selection box on the report
then it does not work on the Jasper reporting server while it is working within iReports.

This so our management or other IT administrators can login on the reporting server website and run the desired reports they like to see.
We have chosen for this because with the build in report designer from SysAid within the Manager Portal we are lacking allot of reports our management wants to see.
I can post more screenshot to explain it better if you like,]]> http://www.sysaid.com/Sysforums/posts/preList/8152/33648.page http://www.sysaid.com/Sysforums/posts/preList/8152/33648.page GMT Well not having a Jasper Reports server, I am not going to be able to help.

Sorry.]]> http://www.sysaid.com/Sysforums/posts/preList/8152/33670.page http://www.sysaid.com/Sysforums/posts/preList/8152/33670.page GMT In order to help you with this issue , please send an email to helpdesk@sysaid.com with a short description of your issue and SysAid's Customer Relations rep will assist you.]]> http://www.sysaid.com/Sysforums/posts/preList/8152/35264.page http://www.sysaid.com/Sysforums/posts/preList/8152/35264.page GMT