BookmarkBookmark this page!
Dec 7, 2023

CRYSTAL Reports Setup for a POR SQL Database


The following documentation provides steps on how to create a connection from Crystal Reports to a POR SQL database using Windows authentication


Prerequisites

The user in question must have read access to the SQL Server and the POR database.


Procedure

  1. If this is for a new report, then go to File->New->Blank Report. If this is an existing report, click Database->Set Datasource Location

 
  1. The window to select a connection will come up. Click “+” next to Create New Connection

  1. Click the “+” next to the OLE DB (ADO) selection

 
  1. The OLE DB Provider window will come up. You are to select a provider compatible to SQL Server. If SQL Server Native Client 11.0 or a higher version is not listed Microsoft OLE DB Provider for SQL Server can also be used
  1. Click Next
  2. On the following window, you input the SQL Server information
  1. Set the following field with their respective information
Server: <SQL Instance Name>,<SQL Listening Port>
Database: POR
Integrated Security: checked (For Windows Authentication)

  1. Click Finish
  2. The OLE DB (ADO) connection should be listed and the tables should be accessible. Select the tables to read from
  1. Click Finish when you are done.

Related Articles