Dynamic Reports and Interactive Charts. A powerful tool for SuiteCRM report creation and data analytics. Includes a variety of chart types, detailed, summary and pivot tables. This Reporting Tool is very user-friendly, no need for technical knowledge or SQL. The Sapiens.BI tool comes with over 100 pre-built reports that are ready to be used on day one.
#1910 - Creating SQL Queries
Is it possible to user your tool in a very primitive way such that we can write our own SQL queries and you tool saves the queries, generates the output and we are able to save as .csv file?
palaphonOther add-ons of interest
Reporting
reports
reporting
analytics
reporting analytics
report analytics
data analytics
sale analytics
sales analytics
analytic reports
analytic reporting
Report
pivot tables
matrix
summary report
charting
sugarcrm charts
advanced reporting
sugarcrm reporting
sugarcrm advanced reporting
sugarcrm analytic reporting
sugarcrm analytic reporting tool
analytic reporting tool
reporting tool
advanced reporting tool
sapiens.bi
sapiensbi
5 years ago
Hello,
Thank you for contacting us! In PRO version (not Basic) - you can write functions for a single field / record based using 'Calculated Functions' or you can write SQL and add it as custom view to be added to the module. But this is not available in Basic version. In both versions you can export report results to xlsx format, which can also be saved as .csv
Best Regards, IT Sapiens Team