Topic: Crosstab view

Can anyone suggest me the best way in Rails to implement a cross tab view which can be updated.

Explanation: I have a narrow, normalized table which should be shown horizontally in the view and should also be updated through view which basically means converting rows to columns while showing and the other way round while updating back to the database.
This can be achieved by writing complex queries(such as pivot in SQL server) but wanted to know if there is an elegant way of implementing it in Rails.

Any suggestion is appreciated, thanks in advance...

Ganesh L

Last edited by gannyprodigy (2011-11-30 04:50:04)