Ruby on Rails reporting tools? [closed]

Question

I am looking for a report generation tool in ruby or rails which allows the user to define a template, then fetch data into the created template.

I have been looking through "The Ruby Box: reporting section."

There are two reporting tools I have looked at:

1. Thin Reports: It is really good. You can create your own report template with the template editor. Then you can produce PDF reports using thinreports gems.

2. ODF Report: You can create a template ODF file using Open Office and MS Word, and you can use that template to generate the report.

Both of these solutions lack the ability to draw charts. Does anyone know of similar reporting tools that can draw charts within a given report?

I have tried the RTF Ruby Library. It works, but shares the limitation that it cannot draw charts and graphs.

The minimum requirements are:

1. Able to create customizable templates. (e.g. design layout, set font size, color, embed images etc.)

2. Able to draw tables and charts.

3. Template could be in Docx or excel or xml or any other common file format.

4. Report output report must be in Docx or RTF format.

Thanks

Answer 1

The axlsx gem is relatively new but seems like a good library. I haven't seen it used for anything more than simple tables yet, but it supposedly supports a lot of other Office Open XML components and features.

From the README:

With Axlsx you can create excel worksheets with charts, images (with links), automated and fixed column widths, customized styles, functions, tables, conditional formatting, print options, comments, merged cells, auto filters, file and stream serialization as well as full schema validation.

If you are using ActiveRecord, there is also acts_as_axlsx from the same author.

Answer 2

Here is an example I found that uses googlecharts api to produce charts for Thinreports:

Embed Graph using GoogleChartAPI

I have not used it though myself.