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 --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
Hi Goin Tan
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
--
Posted via http://www.ruby-forum.com/.
Hello, On Oct 8, 9:58 pm, Goin Tan <goin...-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org> 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