Integrated SSRS Reporting
Microsoft SQL Server Reporting Services (SSRS) is a server-based report generating software system that is part of Microsoft’s SQL Server services suite.
Administered via a Web interface, SSRS can be used to prepare and deliver a variety of interactive and printed reports. The SSRS service provides an interface into Microsoft Visual Studio so that developers as well as SQL administrators can connect to SQL databases and use SSRS tools to format SQL reports in many complex ways. It also provides a Report Builder tool for less technical users to format SQL reports of lesser complexity.
A key advantage to SSRS reports is the flexibility with which they can be delivered to users. Reports can be viewed via a Web browser, on a mobile device, or through e-mail.
Aptean Food & Beverage ERP bcFood Edition expands upon this flexibility, bringing SSRS reporting to your ERP environment. With Aptean Food & Beverage ERP, you can launch SSRS reports directly from within Dynamics.
Integrated SSRS Reporting
With Aptean Food & Beverage ERP, it is possible to run Microsoft SQL Server Reporting Services (SSRS) reports directly from Dynamics. When you integrate SSRS reports with your Dynamics system, you put all the information your users need to perform their tasks right at their fingertips.
Comprehensive report options – use the more than 40 included SSRS reports that come with Aptean Food & Beverage ERP, design your own reports for your specific needs, or create key performance indicators to offer quick insight into your business.
Default settings – specify default filters so that reports are automatically run according to certain criteria, and select from multiple export options, including PDF, Word, and Excel.
Easy access from Dynamics – link your reporting portal to Dynamics and make it possible for your users to run SSRS reports directly from within their ERP environment.
Usage scenario
Group your SSRS reports by department within Dynamics, then tie your users to these groups so that the relevant reports can be easily accessed from each user’s Home page.
Pairing bcFood’s SSRS integration with its data warehouse is a winning combination. The data warehouse contains all the data you need, structured in the way you want it, and you can use this data as the source for your SSRS reports.”
Steve Reynolds, Beck Consulting.