Get articles in reports

[radioguy]

Is their a way to make a report that will show tickets between 2 dates and include articles. I would like to see something like the search function but allowing articles to be exported into the csv. I have done quite a bit of searching but have not found a good way to include this information into the report.

Thanks for the help in advance everyone.

[adam]

Would you want to show every article, or just selected ones (maybe the most recent, or only articles of a specific type)? It's possible with a SQL statement to extract all of the article data, but you'd then have multiple rows for each incident so the desired level of detail and format would dictate how best to do it.

[radioguy]

I have been trying to figure this out. Having multiple lines for the same ticket is ok. We just have to show our customers a list of tickets including the information inside the ticket its self. This report is holding me up from going any further with otrs which is a shame because each of our shops uses ms access right now.

[jojo]

try via SQ (and it is quite uncommon to show articles in a report)

[radioguy]

I know, Do you have any suggestions for running a report out of the sql backend. Software wise. I am currently trying open office but I don't know if there is anything else.

[jojo]

Jasper Rports, Pentao