top of page

Liaison Messenger EDD PLUS

Case Studies

SQL Reporting Services, Crystal Reports and

Microsoft Dynamics GP

CHALLENGE:
A well established 40 year-old Canadian company in Sarnia Ontario, Canada with branch offices in Brantford and London had a need to automate the distribution of their SQL Reporting Services Reports, Crystal Reports and Microsoft Dynamics GP Dexterity Reports.

SOLUTION:

Liaison Messenger EDD gave them the flexibility to create Unattended

Scheduling, Common Recipient Lists, Distribution Groups, and Distribution methods for

the three primary Report Generation tools they use. Namely; Crystal Reports, SSRS (SQL Reporting Services),

and the Microsoft Dynamics GP Dexterity Report Writer.

Messenger EDD allowed them to create EDD Scripts which scheduled and launched: custom SQL Stored Procedures to pre-process the gathered data and then pass it as Parameters/Arguments to launch a myriad of Crystal Reports and SQL Reporting Service reports designed in Report Manager.   

The biggest benefit to this was taking a single report, saved as a PDF by SSRS or Crystal Reports, and Liaison Messenger EDD's amazing ability to parse, split, regroup, and distribute these reports, by Recipient, without having to Re-Write the Report Template.

Instead of focusing on distributing each report, the designer could simply focus on the report and assign it to a pre-defined distribution method in Messenger EDD.  Any and all changes to the distribution, recipients, etc... can now be done within Dynamics GP or Liaison Messenger  WITHOUT having to alter the report template.

Additionally, Liaison Messenger has a flexible Report Scheduler with the ability to store, pass, daisy-chain fields and values and use these as arguments to your Crystal Reports or SSRS Reports for 100% Unattended Processing and Generation.  Schedule and Run repetitive reports, overnight, to free-up resources and have the output waiting in the email inbox of the intended recipients or even at their local printer before they even get in to the office..

This company also uses Liaison Messenger EDD for the distribution of Invoices created in Microsoft Dynamics GP and Work orders from KEY2ACT.  This solutions is talked about in greater detail under the Liaison Messenger EDD Solutions page.

Liaison Software Corporation
20321 Lake Forest Drive, Suite D7
Lake Forest, CA 92630
800.811.4618  - 714.543.9877  -  Fax:  714.543.0887

Get Directions

© 2024 Liaison Software Corporation.

ABOUT US

We're a company based in sunny Southern California, operating under private ownership. Since our inception in 1993, we've been at the forefront of innovation. Our journey began with the development of Liaison CRM, the first commercially available DOS-Windows cross-platform CRM system. Fast forward to today, and our main focus is on crafting Workflow Automation Solutions, with our flagship product, Liaison Messenger, leading the charge since its introduction in 1999.

Liaison Messenger EDD is a crucial part of our offerings, designed to support various accounting systems seamlessly. We prioritize integration with industry leaders like Microsoft Dynamics 365 Business Central, Finance, GP, and SL systems, as well as WennSoft and Sage Software ERP packages including Sage X3, Intacct, Sage 100, Sage 300, and Sage 500. Additionally, we cater to the needs of businesses using exclusively web-based ERP systems such as Acumatica and NetSuite.

bottom of page