| Author |
Message |
![[Post New]](/Sysforums/templates/default/images/icon_minipost_new.gif) 25/12/2008 05:00:32
|
Haim
SysAid Wiz
Joined: 15/04/2008
Messages: 2449
Offline
|
Do these steps to create a simple report "Service Request":
1.log on as a manager then go to design Report then click on the root of the tree "sysaid" then click on the "new report" icon above the tree.
2. a new window will appear with this title "New Report Options" choose Empty Report then click save.
3. in the next window right this string next to the Caption: Service Request
4. in the same window click the Report design tab then click the Browse button next to the "Upload Report File" and choose the Service_Request.jrxml file from the attachment after that click Apply button.
5. move to the Prompt tab (in the same window) then copy the whole text from the attach prompt.txt and put it there after that click the apply button.
6. finally go to the script tab and then copy the whole text from the attach script.txt and put it there after that click the ok button and run the report.
| Filename |
Prompt.txt |
|
| Description |
|
| Filesize |
6 Kbytes
|
| Downloaded: |
209 time(s) |
| Filename |
Script.txt |
|
| Description |
|
| Filesize |
805 bytes
|
| Downloaded: |
189 time(s) |
This message was edited 11 times. Last update was at 25/12/2008 05:56:58
|
Pushing IT forward |
|
|
25/12/2008 05:56:01
|
Haim
SysAid Wiz
Joined: 15/04/2008
Messages: 2449
Offline
|
This is the third attachment
| Filename |
Service_Request.jrxml |
|
| Description |
|
| Filesize |
14 Kbytes
|
| Downloaded: |
177 time(s) |
This message was edited 1 time. Last update was at 25/12/2008 05:56:16
|
Pushing IT forward |
|
|
04/01/2009 10:02:56
|
Lev
SysAid Mod
Joined: 18/08/2008
Messages: 508
Location: Haifa, Israel
Offline
|
Haim
Thank you for this tip.
How can I make this report to show only open requests, or all but closed? I have another category "Reminder" and I would like to exclude it too in the all but closed.
THX
|
DONT !!! DONT TOUCH THE KEYBOARD !!! |
|
|
05/03/2009 23:01:53
|
uniti
SysAider
Joined: 16/06/2008
Messages: 21
Offline
|
Would it be possible to get a Prompt and Script to create the Service Request List report using the Parameters that are in the Helpdesk Service Request lists, where the report is also found there?
In a nutshell I would like to be able to schedule the Service Request report that is generated from the Helpdesk screen (Its not included in the reports package) using all the filter parametres that are available in the Service Request report:
Status
Assigned To
Category
Urgency
This report when generated shows the information set in the Helpdesk views. Could the report also have a selectable view to generate the Service Request report in the Prompt and Script too?
This message was edited 1 time. Last update was at 05/03/2009 23:09:07
|
|
|
08/03/2009 10:58:41
|
Haim
SysAid Wiz
Joined: 15/04/2008
Messages: 2449
Offline
|
Hello uniti,
There is currently no option to schedule reports that are generated from the helpdesk list as they are not "reports" per-say.
You can use the manager portal to customize existing reports and change them to include the information you are looking for and those reports can be customized.
You can read more on how to customize reports in the manager dashboard guide at: http://www.ilient.com/down/manager_portal.pdf
Best regards.
Haim
|
Pushing IT forward |
|
|
26/08/2009 11:43:53
|
andykeppel
Elite SysAider
Joined: 24/06/2009
Messages: 177
Location: Chanhassen, MN USA
Offline
|
Question for you on this...(thanks for the info, this what the primer I needed).
If I do exactly what you say here, it works.
If, however, I take the jrxml file load it into iReport and change something (like bolding a text field), then save it and upload the new report to SysAid, it only works as an Excel file.
The PDF only shows the Report Title, "Generated On", the Date, and the Horizontal Line. The Applet doesn't work. The Excel file gives me the full report (everything executes fine within iReport, but once it's on the server, it has issues with PDF and Java)
I reverted back to iReport 1.2.2 from 3.x because someone on the forums said that 3.x doesn't work (and they're right). Any thoughts?
|
Andrew Keppel
"if it's stupid but it works, it isn't stupid" |
|
|
26/08/2009 14:11:37
|
Haim
SysAid Wiz
Joined: 15/04/2008
Messages: 2449
Offline
|
You can upload the jrxml along with the error you receive in the SysAid.log file when you try to run this report on PDF and i'll try to see if there are any pointers we can give you.
Regards.
Haim
|
Pushing IT forward |
|
|
16/09/2009 13:12:17
|
andykeppel
Elite SysAider
Joined: 24/06/2009
Messages: 177
Location: Chanhassen, MN USA
Offline
|
Thanks Haim.
I have the XLS that was created successfully, along with the PDF that's not working, and the log-file at the time I was trying to pull the report.
The SysAid log appears to say that PDF-lib can't find Helvetica, but all of the fonts in the report are Arial, and it's generating the title and headers without a problem.
| Filename |
SysAid.txt |
|
| Description |
|
| Filesize |
12 Kbytes
|
| Downloaded: |
16 time(s) |
This message was edited 3 times. Last update was at 16/09/2009 13:13:07
|
Andrew Keppel
"if it's stupid but it works, it isn't stupid" |
|
|
16/09/2009 13:13:44
|
andykeppel
Elite SysAider
Joined: 24/06/2009
Messages: 177
Location: Chanhassen, MN USA
Offline
|
hm...the forum isn't letting me add multiple attachments...
| Filename |
Service_Requests.jrxml |
|
| Description |
|
| Filesize |
12 Kbytes
|
| Downloaded: |
12 time(s) |
|
Andrew Keppel
"if it's stupid but it works, it isn't stupid" |
|
|
16/09/2009 17:29:44
|
andykeppel
Elite SysAider
Joined: 24/06/2009
Messages: 177
Location: Chanhassen, MN USA
Offline
|
Yeah, ok, I think I got this one figured out. Ignore all my stuff.
|
Andrew Keppel
"if it's stupid but it works, it isn't stupid" |
|
|
19/10/2009 16:58:18
|
ryansm
SysAider
Joined: 14/10/2009
Messages: 1
Offline
|
How can I take this basic report and filter for closed tickets in the last month. Then filters for certain categories and then subcategories?
Your assistance is appreciated.
|
|
|
05/11/2009 11:27:24
|
andykeppel
Elite SysAider
Joined: 24/06/2009
Messages: 177
Location: Chanhassen, MN USA
Offline
|
Go to the "Report Query" tool in iReport and add
Be sure to add the parameters into the prompt, the script, and the jrxml (via iReport).
PROMPT:
Add the following code snippits into your prompt (take out the line numbers). I added them immediately after:
<td class="Form_Ctrl_Fields">
<table class="Maxed">
<tr>
<td class="FieldBox">
${reportTitleDesign}
</td>
</tr>
</table>
</td>
</tr>
SCRIPT:
Add the following into your script.
IREPORT PROCESS:
Follow these steps to add the parameters into your report template.
- Open up your report in iReport v1.2.2 or v1.2.3
- Select View > Parameters
- Select the New button
- Type REPORT_YEAR in the Parameter Name box
- Select java.lang.String in the Parameter class type box
- Check the Is for prompting box
- Click OK and repeat for REPORT_MONTH
- Save your report.
|
Andrew Keppel
"if it's stupid but it works, it isn't stupid" |
|
|
05/04/2010 10:24:32
|
limbo
SysAider
Joined: 14/07/2008
Messages: 2
Offline
|
Hi Haim,
Thanks for this. When I run the report I get the following error
<HTML><HEAD><META http-equiv="Content-Type" content="text/html; charset=iso-8859-1"/></HEAD><BODY dir=""><script>
alert("No data found");
window.close();
</script></BODY></HTML>
Am I missing something? I'm running version 6.5.08.
Thanks,
Keith
This message was edited 1 time. Last update was at 05/04/2010 10:25:38
|
|
|
08/04/2010 08:58:18
|
itayH
SysAid Customer Relations
Joined: 23/09/2009
Messages: 1092
Offline
|
Hi Keith,
Can you give us more information please?
You can also attach SysAid.log
You can also send us an email to helpdesk@sysaid.com or open a SR in http://helpdesk.ilient.com regarding this issue with short description and after recreating the issue attach:
...\SysAidServer\root\WEB-INF\logs folder (zipped)
...\SysAidServer\root\WEB-INF\conf\serverConf.xml
...\SysAidServer\tomcat\logs
...\SysAidServer\logs\wrapper.log
|
Best Regards,
Itay |
|
|
10/03/2011 09:22:15
|
5.7FSN
SysAid Wiz
Joined: 15/04/2010
Messages: 376
Offline
|
andykeppel wrote:Thanks Haim.
I have the XLS that was created successfully, along with the PDF that's not working, and the log-file at the time I was trying to pull the report.
The SysAid log appears to say that PDF-lib can't find Helvetica, but all of the fonts in the report are Arial, and it's generating the title and headers without a problem.
Sorry to Bump an old thread, but what was the cause of this. Everything in my report says it's Arial, yet the log says it can't find helvetica? I'm using 1.2.3 (had previous newer versions). If I open and just save the file (was working), and then upload it, it generates the error. Excel and Java works just fine, just no PDF
|
|
|
![[Up]](/Sysforums/templates/default/images/icon_up.gif){kind=icon}
