For any report that you create (using Forena), just add .csv
as an extention to the report (output) URL. That contains the CSV equivalent of that report.
As a sample, consider the sample report located at /reports/sample.states
(in your own site, one of the samples shipped with Forena). Change the URL to /reports/sample.states.csv
(= just add .csv
to it) to get the same report in .csv
format.
If you'd adding such .csv
to the URL of the Simple Table of States in the demo site, the result is like so ...
Same technique applies for other supported extensions (export formats), such as adding .html
, .xls
(MS Excell), .pdf
or .doc
(MS Word).
By the way, all data blocks are accessible directly via their url also, provided you have permission to access that block. Here are a few samples of that, for the sample report located at /reports/sample.states
:
- in XML format (= demo with anonymous access).
- in JSON format (= demo with anonymous access).
- in XML format (from the= demo sitewithout anonymous access).
- in JSON format (from the= demo sitewithout anonymous access).