Liaison Messenger EDD PLUS

Case Studies

SQL Reporting Services, Crystal Reports and

Microsoft Dynamics GP

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.


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
11 Orchard, Suite 108
Lake Forest, CA 92630
800.811.4618  - 714.543.9877  -  Fax:  714.543.0887

Get Directions

© 2020 Liaison Software Corporation.


Liaison Software Corporation is a privately held company, located in Southern California. Founded in 1993, Liaison Software developed the first commercially available DOS-Windows cross-platform CRM system. That product, Liaison CRM, is still available today in it's 6th version.

Liaison Software Company, LLC incorporated in March of 2001 and was renamed; Liaison Software Corporation. 

During the 2000s, Liaison focused their efforts into expanding their Liaison Messenger product into the booming Microsoft Great Plains and Solomon IV Accounting market which later became Microsft Dynamics GP and SL. Liaison Software Corporation is a Certified Partner and Certified Independent Software developer for Microsoft Corporation as well as a strategic Development Partner for Sage Software.

Becoming an Integrated Solutions Vendor for Epicor in 1995, Liaison has expanded its offerings and now develops Workflow Automation Solutions that supports a wide array of accounting systems with an emphasize for Sage Software’s Sage 100, Sage 300, Sage 500, & Sage X3 and the entire line of Microsoft Dynamics AX, GP, SL, NAV, and 365 products.