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
- Launch Crystal Reports Designer
- Create a new report
- Click on Database --> Database Export --> OLE DB (ADO) --> Microsoft OLE DB Provider SQL Server --> Next
- On next windows enter the Server name, UserID, Password (gotomyerp will provide this)
- Select the Database you would like to connect to then click on Finish
Related Articles
Setting up Scheduled Reports in Quickbooks v17 and newer
Intuit has introduced "Scheduled Reports" in Quickbooks Enterprise v17 and newer. Unfortunately, this is not a feature that will work in a hosted environment, per Intuit. ...
How to improve the performance of your QuickBooks company file
Summary: Like every database-driven software, maintenance is required on a regular basis to keep your database (or in the case of QuickBooks, your Company File) healthy. This article will walk you through a few tips that will help you keep your file ...
QuickBooks reports are slow when exporting to Excel worksheet
Problem When exporting a QuickBooks report to Excel, the export process is very slow. Resolution While in QuickBooks, perform the following: Open your QuickBooks company file Run a report to export to Excel Select Excel > Create New Worksheet Click ...
The Report Designer Component is required by this report and is not installed on this workstation
Problem When you try to run the Report Manager from Sage Intelligence reporting module in SAGE you get an error "The Report Designer Component is required by this report and is not installed on this workstation" Why Is This Happening? Report manager ...
Connection is unstable or impossible when connecting through VPN
Problem When connecting to the gotomyerp-hosted applications from within your company's network, the connection is successful and stable. When connecting from a remote location, home, or from a company's network, and a VPN is connected, the user ...