05 - Customized Simple Table of States

This report is a variation of the Simple Table of States report, i.e.:

  • it uses a custom Report Skin.
  • the data are shown using the dataTables plugin.
  • it allows for exporting the report data in various file formats.

Theming the Report

Some more details about the customizations that were applied to produce this report:

  1. The report (table) is displayed using the dataTables plugin by adding the JavaScript datatables_features.js in the custom skin. Which adds various widgets to operate on the data contained in the table, such as (above the table) the search box and the number of entries to be shown, and (below the table) the pagination and the number of rows. Type a few letters in the search box to get the idea. See the dataTables documentation for more information on this JQuery plugin.
  2. The presentation of the dataTables controls are themed by adding the stylesheet datatables_styling.css
    in the custom skin.
  3. Some of Forena's default styling is refined (e.g. the size of the edit icons), by adding the stylesheet forena_styling.css in the custom skin.

Export the Report Data

Various document types have been enabled to make the hyperlinks (upper right) available, so that the report data (= query results) can be saved (exported) in the desired format, such as CSV, HTML, DOC, XLS (incomplete list ...). With that, it makes Forena a valid alternative for the Views Data Export module also.

Actual Report

code name
AL Alabama
AK Alaska
AS American Samoa
AZ Arizona
AR Arkansas
CA California
CO Colorado
CT Connecticut
DE Delaware
DC District of Columbia
FM Federated statess of Micronesia
FL Florida
GA Georgia
GU Guam
HI Hawaii
ID Idaho
IL Illinois
IN Indiana
IA Iowa
KS Kansas
KY Kentucky
LA Louisiana
ME Maine
MH Marshall Islands
MD Maryland
MA Massachusetts
MI Michigan
MN Minnesota
MS Mississippi
MO Missouri
MT Montana
NE Nebraska
NV Nevada
NH New Hampshire
NJ New Jersey
NM New Mexico
NY New York
NC North Carolina
ND North Dakota
MP Northern Mariana Islands
OH Ohio
OK Oklahoma
OR Oregon
PW Palau
PA Pennsylvania
PR Puerto Rico
RI Rhode Island
SC South Carolina
SD South Dakota
TN Tennessee
TX Texas
UT Utah
VT Vermont
VI Virgin Islands
VA Virginia
WV West Virginia
WI Wisconsin
WY Wyoming