Heavy reports with a lot of calculations

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

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

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

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs