Connecting Crystal Reports Designer with Acctivate Database

Connecting Cyrstal Reports Designer to Acctivate Database

Description

Need to connect Crystal Reports Designer to Acctivate Database

Prerequisites

You need an SQL username and password that has access to the database. gotomyerp can create a user upon request.
You need to be subscribed to Cyrstal Reports Designer

How to connect

  1. Launch Crystal Reports Designer
  2. Create a new report
  3. Click on Database --> Database Export --> OLE DB (ADO) --> Microsoft OLE DB Provider SQL Server --> Next
  4. On next windows enter the Server name, UserID, Password (gotomyerp will provide this)
  5. Select the Database you would like to connect to then click on Finish