In order to make optimal decisions for your company, you require reporting tailored to your own business priorities and needs. In my previous blog Insight in your daily business I explained how Reporting Services can help you making these key decisions. Reporting Services, part of SQL Server 2005 and higher, is a worldwide known web reporting tool. It enables you to create flexible and graphical web reports. Exact Reporting Services Integration connects these required values into your familiar environment Exact Synergy Enterprise. Exact Reporting Services Integration centralizes the benefits from both products.
The integration of Reporting Services into Synergy Enterprise, enables you to adapt all important functionalities of Reporting Services.
Benefits or important functionalities of Reporting Services are:
- Create flexible and graphical reports
- Use different data sources for the reports
- Export reports in different formats like PDF, Excel and Word.
This integration offers the below possibilities from within Synergy Enterprise:
- Store reports in Synergy Enterprise.
- Create various data sources and link them to reports.
- Deploy reports from Synergy Enterprise to a Report Server.
- Assign specific roles (rights) to reports.
- Export reports in different formats, e.g. PDF, Excel and Word.
- Save reports as a document (snapshot).
- View reports as a web part on e.g. your homepage (dashboard).
- Several entities can be used as filter in reports to show specific related data.
With Reporting Services Integration you have one central system with the functionalities of Synergy Enterprise enriched with Reporting Services.
SQL Server and SQL Server Analysis Services data sources can be created and linked to reports. This allows you to show reports on other products, beside Exact Synergy Enterprise, which uses a SQL Server database, e.g. Exact Globe.
Roles can be assigned to reports. This gives you the flexibility and possibility to control rights to reports, in the same way as you are used to do for other data or functionality. So create a report once and limit the data shown on the report, based on a user’s role within the company.
Reports can be saved as a document (snapshot). This offers you to create an archive of results. This can be used for comparison with the current result.
Reports can be viewed via web parts on your homepage as well on other on other pages. With this functionality you can create your own dashboard which gives you directly clear insight into your business processes in order to make optimal key decisions.
Reports can be started from several entities in Synergy Enterprise, e.g. person’s card, account card and project card. The great thing about this is that you design a report once and when started the content is automatically about the customer at hand, such as the outstanding amount of the customer.
Stay tuned about the next steps in giving you more control over your business.
Photo credit: Naddsy