Reporting Against Relational Data¶
CALUMO enables reporting and data writeback against traditional relational SQL server data stores as well as OLAP based Analysis Services.
This can be implemented via any of the following :
- Custom Tables
- Editable Tables / CTABLEEDITOR
- CGETSQL / CREFLEXTABLE based reports
A new set of formula and Editable Tables features have been introduced that let you create and manage your own sets of tables (Custom Tables) as well as creating reports and input forms using these, or other, tables. The new CGETSQL formula allows you to bring back a single value by key and table from SQL Server, just like CGET does for data from Analysis Services.