In this Section
RAD Software Solutions: SQL SERVER REPORTING SERVICES for EFACS ERP
SQL Server Reporting Services provides a full range of ready-to-use tools and services within EFACS ERP to help you create, deploy, and manage reports for your organisation, as well as programming features that enable you to extend and customise your reporting functionality. SSRS is a standard feature within SQL Server 2008 meaning no additional licenses are required to develop extensive reports and intelligence.
With Reporting Services, you can create interactive, tabular, graphical, or free-form reports from relational, multidimensional, or XML-based data sources. You can publish reports, schedule report processing, or access reports on-demand. Reporting Services also enables you to create ad hoc reports based on predefined models, and to interactively explore data within the model. You can select from a variety of viewing formats, export reports to other applications, and subscribe to published reports. The reports that you create can be viewed over a Web-based connection or as part of a Microsoft Windows application or SharePoint site. Reporting Services provides the key to your business and manufacturing data.
Key Capabilities
- Accelerate insight with intuitive and flexible authoring capabilities.
- Access and combine data from virtually any data source.
- Securely view and share reports directly from the web.
- Streamline collaboration and management by using integration with Microsoft SharePoint Server.
- Scale as needed.
Use a comprehensive report design environment.
Benefit from increased productivity through familiar Microsoft Visual Studio-based report development tools. Take advantage of intuitive design interfaces and wizards to quickly build reporting solutions
Create reports from a wide range of alternative databases and sources
Build reports from different data sources throughout your enterprise. Data sources can be from SQL Server itself or Oracle, DB2, SQL Azure, PowerPoint Workbooks and others.
Enable report authoring for business users
Enable business users to create their own reports and explore corporate data by using Microsoft Report Builder 3.0, an intuitive and familiar Microsoft Office-optimized authoring environment.
Format reports in the way that makes most sense for your particular reporting needs
Use a tabular format for fixed data reports and Matrix format for dynamic crosstab reports; or combine the two formats by using the new highly innovative data representation format of TABLIX™
Visualize data
Enrich reports by visualizing data graphically, leveraging a wealth of new rich mapping, gauge and charting capabilities. Take advantage of additional chart enhancements including annotations, custom colour palettes, scale breaks, merged charts, and multiple axes.
