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:
- 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.
- The presentation of the dataTables controls are themed by adding the stylesheet datatables_styling.css
in the custom skin. - 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 |
WA | Washington |
WV | West Virginia |
WI | Wisconsin |
WY | Wyoming |