public
Description: create reports via sql or ruby code for your rails app in minutes
Homepage: http://upstream-berlin.com/blog/open-source/#dead_simple_reports
Clone URL: git://github.com/langalex/dead_simple_reports.git
100644 30 lines (14 sloc) 1.14 kb
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
== dead simple reports ==
 
this rails plugin allows you to easily create and view arbitrary reports of your database tables. it therefore creates a reports controller with views and a report model in your application. to create a report you simply create an instance of Report. it then appears in the list of reports where you can view it either as html, csv or xls table.
 
=== to create a report ===
 
Report.create! :name => 'My Ruby Report', :kind => 'code', :code => 'User.find(:all).map(:&name)'
 
This will generate a report that lists all user's names.
 
Alternatively you can create a sql report:
 
Report.create! :name => 'My SQL Report', :kind => 'sql', :code => 'SELECT name FROM users'
 
to view the list of reports just go to http://localhost:3000/reports
 
=== customizing the views ===
 
to customzie the views you can simply edit the files under app/views/reports in your application.
 
== customizing the controller ==
 
to customize the controller you can add code to the app/controllers/reports_controller file generated in your application.
 
 
=== contact ===
 
for hints, questions etc. please email alex[at]upstream-berlin.com