Heavy reports with a lot of calculations

Rails
1

Hello,

I am working on reports now where we are using MySQL (InnoDB) and Rails
2.3.4.

Tables are big and there are a lot of calculation with several big
tables.
Please give me some suggestions whether there any gem, plugin, articles,
or
techniques that allows me to create heavy reports.

I am even going to use cron job that allows me to calculate some middle
data
in order to provide heavy reports more faster to end users.

Also I am interesting whether anybody has an experience with
JasperReport.
What are benefits and disadvantages of using it?

Regards,
Olga

2

Hi Goin T.

In our project we use for generating excel reports  the gem

‘spreadsheet’
http://rubyforge.org/projects/spreadsheet/

For pdf reports we use the gem ‘prawn’
http://prawn.majesticseacreature.com/

Sijo

3

Hello,

On Oct 8, 9:58 pm, Goin T. [email protected] wrote:

Tables are big and there are a lot of calculation with several big tables.
Please give me some suggestions whether there any gem, plugin, articles, or
techniques that allows me to create heavy reports.

I’ve been using Ruby Reports (http://rubyreports.org/) and have been
very happy with it. It’s geared specifically towards generating
reports, so it provides a data manipulation functions (sum row, add
column, etc) in addition to formatting. It also has AR integration
through the acts_as_reportable gem.

Sean