FW: Ticket Report We Use

Ok, here is the report we use, something simple that perhaps the community can build upon.

Cheers
HelmuthFrom: Helmuth Ramirez
Sent: Thu 3/29/2007 5:25 PM
To: rt-users@lists.bestpractical.com
Subject: Ticket Report We Use

Hi everyone,
Management wanted a report to review the number of open/closed tickets on a daily basis. Our Helpdesk Supervisor knows a little Crystal and came up with a simple report. I would like to submit it to the community in case anyone else could use something like this and/or improve on it. (share the wealth right?).

Attached is an image file with what it looks like, as well as the Crystal Reports rpt file.

Cheers
Helmuth

This Electronic message contains information from CompuPay which may
be privileged. The information is intended to be for the use of the
addressee only. If you are not the addressee, or the employee or agent
responsible to deliver it to the intended recipient, note that any
disclosure, copy distribution or use of the contents of this message
is prohibited. If you have received this Electronic Message in error,
please promptly notify the sender by return e-mail. For more
information regarding our company please visit www.compupay.com
http://www.compupay.com/

Daily IT.RPT (61.5 KB)

Hi,

Please can you brifly explain how to generate this. I couldn’t get how to
generate this type of Report.

Regards
SanthoshOn 6/20/07, Helmuth Ramirez HelmuthRamirez@compupay.com wrote:

Ok, here is the report we use, something simple that perhaps the
community can build upon.

Cheers
Helmuth


From: Helmuth Ramirez
Sent: Thu 3/29/2007 5:25 PM
To: rt-users@lists.bestpractical.com
Subject: Ticket Report We Use

Hi everyone,
Management wanted a report to review the number of open/closed tickets
on a daily basis. Our Helpdesk Supervisor knows a little Crystal and came
up with a simple report. I would like to submit it to the community in case
anyone else could use something like this and/or improve on it. (share the
wealth right?).

Attached is an image file with what it looks like, as well as the Crystal
Reports rpt file.

Cheers
Helmuth


This Electronic message contains information from CompuPay which may
be privileged. The information is intended to be for the use of the
addressee only. If you are not the addressee, or the employee or agent
responsible to deliver it to the intended recipient, note that any
disclosure, copy distribution or use of the contents of this message
is prohibited. If you have received this Electronic Message in error,
please promptly notify the sender by return e-mail. For more
information regarding our company please visit www.compupay.com
http://www.compupay.com/


The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Ok, here is the report we use, something simple that perhaps the
community can build upon.

Helmuth, can you point us in the right direction on how to get this
report running on our RT?

Thx
Seb.-

Hi everyone, here is what I was told by the person who created the report, I hope this helps:

In crystal, they have to go to Database>Set Location, click on each of the tables then “set location” and find the database/table. This remaps the tables to their database and they should be able to run the report.

Nick Del Carpio
CompuPay
IT HelpDesk
3450 Lakeside Dr.
Suite 400
Miramar, FL 33027
954-874-4888From: sebsua@gmail.com
To: Helmuth Ramirez
CC: kelly.terry.jones@gmail.com; rt-users@bestpractical.com; Jesse Vincent
Sent: Wed Jun 20 09:56:29 2007
Subject: Re: [rt-users] FW: Ticket Report We Use

Ok, here is the report we use, something simple that perhaps the
community can build upon.

Helmuth, can you point us in the right direction on how to get this
report running on our RT?

Thx
Seb.-

This Electronic message contains information from CompuPay which may
be privileged. The information is intended to be for the use of the
addressee only. If you are not the addressee, or the employee or agent
responsible to deliver it to the intended recipient, note that any
disclosure, copy distribution or use of the contents of this message
is prohibited. If you have received this Electronic Message in error,
please promptly notify the sender by return e-mail. For more
information regarding our company please visit www.compupay.com
http://www.compupay.com/

Anyone worked on JasperReports and RT?El Jue, 21-06-2007 a las 12:17 -0400, Helmuth Ramirez escribió:

Hi everyone, here is what I was told by the person who created the
report, I hope this helps:

In crystal, they have to go to Database>Set Location, click on each of
the tables then “set location” and find the database/table. This
remaps the tables to their database and they should be able to run the
report.

Nick Del Carpio
CompuPay
IT HelpDesk
3450 Lakeside Dr.
Suite 400
Miramar, FL 33027
954-874-4888

-----Original Message-----
From: sebsua@gmail.com
To: Helmuth Ramirez
CC: kelly.terry.jones@gmail.com; rt-users@bestpractical.com; Jesse
Vincent
Sent: Wed Jun 20 09:56:29 2007
Subject: Re: [rt-users] FW: Ticket Report We Use

El Mar, 19-06-2007 a las 16:12 -0400, Helmuth Ramirez escribió:

Ok, here is the report we use, something simple that perhaps the
community can build upon.

Helmuth, can you point us in the right direction on how to get this
report running on our RT?

Thx
Seb.-


This Electronic message contains information from CompuPay which may
be privileged. The information is intended to be for the use of the
addressee only. If you are not the addressee, or the employee or
agent
responsible to deliver it to the intended recipient, note that any
disclosure, copy distribution or use of the contents of this message
is prohibited. If you have received this Electronic Message in error,
please promptly notify the sender by return e-mail. For more
information regarding our company please visit www.compupay.com
http://www.compupay.com/

sebsua@gmail.com wrote:

Anyone worked on JasperReports and RT?
Yes, I created a report to count the hours spend by queue by staff
member per month.I’m using iReports which is using JasperReports as its
engine I believe.

Joop