Submitted by metzlerd on Sat, 04/01/2017 - 09:25 What types of data do you report? Reporting on drupal entities and nodes Reporting on external databases Reporting on external data stored in my own drupal database Please indicate which types of data you present using Forena. How do you create reports? I use my Drupal sites report editor to create reports (amin/structure/forena) I create reports using a text editor and manually upload them. Please indicate how you create reports in Forena How do you create SQL Data blocks I use a text editor to create the sql queries I use the query builder in my drupal site to create SQL queries (admin/structure/forena/data) Describe how you most commonly create .sql files that make up forena reports. Which features do you use? Basic report writing freatures List of reports for which users have access Creating reports in more than one language Making charts and graphs in SVG Email merge reports Xml reports Ajax report loading features PDF document generation Excel Exports Csv exports Word document exports JSON Data blocks Drupal Views integration Advertising menu items for reports Indicate any of the features that you use in forena. Where is forena used? Commerce sites selling goods or services Not for profit or charitable sites Social networking sites Educational sites, college sites or schools Governmental web sites Sites collecting or presenting scientific research Sites performing outreach and donation collection for charities Sites presenting ERP or BI or other business data internally Other sites not described above Describe the types of sites that most commonly presented data by forena. Check all that apply. What caused you to explore Forena to begin with? Need direct control of presentations not afforded to me by views Need to consume data from external data sources in Drupal Needed to write queries that were to hard to write in views. Need to produce graphs and charts on my web site. Needed to present Dynamic PDF documents to users Other reasons not described above Was looking for a traditional report writer. What features best desribe the reason that you were drawn to Forena as a product to begin with?