Welcome to the Exact Product Blog

On this blog we will cover stories from all around the Exact ecosystem.

Posts Tagged ‘SQL Reporting Services’

Rafiki’s Corner – Exact Event Manager 1.6 – A Bag of Tricks

Written by Sander van Triet on . Posted in Exact Event Manager

Effective Tuesday, May 4, Exact Event Manager 1.6 went into extended internal testing and QA (Regional Verification Testing). This exercise will take place in Columbus, OH where we are privileged to have 3 colleagues from Delft with us, who will assist in shaking the latest release out. By bringing people from around the world together into one room, we will further ensure that communications and ideas are consistent and focused. There is nothing like breaking down time-zone governed barriers!

Event Manager 1.6 is a cumulative release that contains a significant number of software corrections, some smaller user improvements and 2 new features:

  • Support for SQL Server Reporting Services as an action
  • Uploading of attachments into Synergy Enterprise as documents

These two enhancements were requested by groups across all regions and represent the growing trend of market / customer driven solutions.

Support for SQL Server Reporting Services

When setting up SSRS as an Action, you are able to define the format of the output as either

  • MS-Word
  • Excel
  • Adobe .pdf
  • HTML 4
  • CSV

So, what does this mean to everyone? Well, the attachments that are sent with the outbound email, as the action, mean that the user can take advantage of the significant features found within Excel, Word etc. For example team members here have been playing around with conditional formatting, which will be controlled by Excel or Word.

Uploading Documents as Attachments to Synergy Enterprise

Tapping into the extended opportunities provided to us by the entities exposed with Synergy Enterprise, you are now able to take a Crystal Report and upload that into Synergy Enterprise as a document with the the report attached to the document. Furthermore, making use of the power of SQL Server Reporting Services, the same holds true here. You are able to define an Event where the action is to create a Document, and you have the option to select a SSRS document to be uploaded into Synergy Enterprise, as an attachment. This means that you can select either a pdf, Word, Excel, HTML 4 or CSV attachment to Synergy.

The use of the Entities with Synergy Enterprise, further allows you to ensure that the document types and all properties associated with the document classification are exposed and correctly filled in within Exact Event Manager.

Exact Event Manager 1.6 is a major milestone for the solution. We are now stepping into new areas of capabilities never before seen, and embracing newer technologies and concepts such as SSRS and entity integration. For more information, keep watching my blog. I will not be silent and will continue to communicate!