This is your basic "cross-tab" report.
However, since you did not provide a layout of your table(s), it''s not
really possible to help you with the query.
So, perhaps this will help:
http://www.simple-talk.com/sql/t-sql-programming/creating-cross-tab-queries-and-pivot-tables-in-sql/
or you can google "crosstab reports in rails"
HTH,
Dan
On Tuesday, May 15, 2012 2:45:06 AM UTC-4, Ruby-Forum.com User
wrote:>
> Report
>
> I need to create a daily report + monthly report with this records..
>
> Calls
> Texts
> Emails
>
> Is there any possible way to create a single query that will
> generate this daily report + monthly report.?
>
> Ex.
>
> Day1 Day2 Day3 etc.. Total
> Calls 20 23 23 ... 66
>
> Texts 120 125 130 ... 375
>
> Emails 50 60 55 ... 165
>
> Total 190 208 208 ... 606
>
>
> If not, please tell how to do it the simplest way, and how to this on
> rails.?
>
> Thanks in advance...
>
> --
> Posted via http://www.ruby-forum.com/.
>
--
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/rubyonrails-talk/-/MSBsbzsBiqEJ.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en.