generating a new report

[fireburn]

good morning ...
i am a litle noob @ otrs but with very much will to learn ..

i was given the task to create a report to be generated weekly or monthly with these parameters

date of creation
date of response
subject of ticket and customer id ...


can someone help me in this ..
i know the report can be added in cron so it whould generated automaticly .. my problem is design the reports ..

thanks ..

[CSL]

You'll want to try designing your reports in the interface first. The documentation is the best place to start: http://doc.otrs.org/3.1/en/html/statistic-module.html

Once you've got a report working, you can use the script /opt/otrs/bin/otrs.GenerateStats.pl to automate the running of the report through cron: http://doc.otrs.org/3.1/en/html/stats-m ... admin.html

[rafaelpastre]

Dear friend!

This is a simple kind of report.
-In the 1st Step, chose the dynamic object to "ticket list" and CSV format.
-In the 2nd Step, chose the fields that you need to print on your report. (I belive that in your case is "Create Time", "Response Time", "Title" and "Custmor ID")
-In the 3rd Step, chose the order method.
-In the 4 Step, chose the filter (if need to exists).

I created one report with those steps and it was generated correctly.

Maybe it helps you.

[fireburn]

thanks you guys ...
about cron i already found out that ..
but its was what rafaelpastre told that i was looking ..

i will test it and report to you guys ..

thanks in advance ..

[fireburn]

it was like you said .. but now i need to do something a litle more hard ..i need to generate a map with percentage of request that are replayed within 4 hours

for exemple

100 tickets

75% are replayed within 4 hour corresponds with 75%
the others correspond to 25%


this as to do with SLA... i am starting with this .. so bare with me ..


anyone as any ideias