Return to Sage 200 Home Page.png
View Product in Action.png
View ScreenShots.png eBrochures and Downloads.png
Book a Demo.png

 

 

 

 

Introduction

The A La Carte SQL Reporting module allows powerful and intuitive reports and analyses to be developed on top of Microsoft SQL Server or Oracle Data Warehouses from within native Excel.

 

The process is simple to empower end users to create and maintain their reports :
 

  • IT sets up data Views on Tables that the end users wish to analyse from their Operational, CRM or Data Warehouse applications
  • End users interact directly with these Tables from within the familiarity of Excel, using the A La Carte SQL Reporting addin

If you want to build sophisticated transactional reports as an Excel user and don’t have the skills or desire to use a separate tool outside of Excel such as Microsoft Reporting Services, then A La Carte SQL Reporting module is the tool for you. ROI in hours.
 

gauge chart updated data.png?
 

Sourcing Data For Your Reports

Data can be added from any data type below or from multiple sources.

Examples include :

  • Tables or Views from Microsoft SQL Server
  • Tables or Views from Oracle
  • Tables or Views from Microsoft Access
  • Excel Tables

In addition, multiple reports can be linked together (link Product, Customer, Time Period etc) with common attributes thus transforming separate reports into powerful integrated transactional reporting applications.

 

Benefits

  • Return on investment (ROI) can be achieved within hours / days. If you have Views setup on your SQL Server and/or Oracle data, simply install and start building.
  • Professionally designed reports can be developed quickly without any detailed knowledge of Excel.
  • Data can be easily sorted, filtered and zero suppressed for advanced analytical requirements
  • Low cost and simplicity of licensing. Licenses are available for unlimited users for a country or unlimited users worldwide. No per user, per feature, per author / user complexity which alternative solutions tend to add to pricing considerations, usually resulting in unexpected costs.
  • Run anywhere. Reports can be deployed on PCs/Laptops/Slates or via Windows Terminal Services providing access from iOS, Android and Windows Phone mobile devices.

 

Integration With Other A La Carte Modules

  • When used in conjunction with the Dashboard module, the A La Carte SQL Reporting module can make Dashboards available across your entire Data Warehouse.
  • When used in conjunction with the Cube Reporting module, the A La Carte SQL Reporting module can facilitate SQL Reports and Cube Reports in the same worksheet / workbook and where there are common parameters, these can be linked across both types of reports. This would allow you to have say a report showing the customer transactions for a named Customer  sourced from a SQL Server or Oracle View linked to a Top n Customer report sourced from SQL Server Analysis Services. Operational detail and summarised Management Reporting seamlessly linked.
  • When used in conjunction with the Report Distribution module, reports can be setup to run static copies (output as Excel, PDF and/or Single Web Archive format reports) based on user security. So you could send each Product Manager a Transactional Sales Report for just his /her Product(s) and these would automatically be output each day, week, month etc.