| Author |
Message |
![[Post New]](/Sysforums/templates/default/images/icon_minipost_new.gif) 29/02/2012 15:00:48
|
NWG-IT
Elite SysAider
Joined: 07/01/2010
Messages: 203
Offline
|
Hello All,
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:
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)
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.
This message was edited 4 times. Last update was at 29/02/2012 15:10:15
|
|
|
29/02/2012 15:08:00
|
Paauwtje
SysAider
Joined: 29/02/2012
Messages: 2
Offline
|
Hi NWG-IT,
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
|
|
|
01/03/2012 11:56:28
|
techguy
SysAid Mod
Joined: 11/06/2008
Messages: 1506
Location: England
Offline
|
I am no expert in this area, but if you are running the query directly in the report, then I think you have to specify the connection string to the database in the report.
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).
|
Need help? Try the SysAid wiki first! - http://sites.google.com/site/sysaidwiki |
|
|
01/03/2012 12:26:21
|
Paauwtje
SysAider
Joined: 29/02/2012
Messages: 2
Offline
|
Hi Techguy,
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
|
|
|
01/03/2012 12:29:47
|
NWG-IT
Elite SysAider
Joined: 07/01/2010
Messages: 203
Offline
|
Thanks for the replies,
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.
|
|
|
01/03/2012 14:44:05
|
techguy
SysAid Mod
Joined: 11/06/2008
Messages: 1506
Location: England
Offline
|
you keep taking about the "Jasper Server" do you mean when you run the report from SysAid?
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
|
Need help? Try the SysAid wiki first! - http://sites.google.com/site/sysaidwiki |
|
|
01/03/2012 15:15:01
|
NWG-IT
Elite SysAider
Joined: 07/01/2010
Messages: 203
Offline
|
techguy wrote:you keep taking about the "Jasper Server" do you mean when you run the report from SysAid?
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,
This message was edited 2 times. Last update was at 01/03/2012 15:18:15
|
|
|
02/03/2012 17:13:34
|
techguy
SysAid Mod
Joined: 11/06/2008
Messages: 1506
Location: England
Offline
|
Ok, now I get what you are saying ( I had not heard of jasper reports server - I thought you were running the reports that you had created from the analyser in SysAid).
Well not having a Jasper Reports server, I am not going to be able to help.
Sorry.
|
Need help? Try the SysAid wiki first! - http://sites.google.com/site/sysaidwiki |
|
|
19/07/2012 10:20:11
|
jorgiani
SysAider
Joined: 11/05/2011
Messages: 6
Online
|
Hello All,
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.
|
|
|
![[Up]](/Sysforums/templates/default/images/icon_up.gif){kind=icon}
