Was this article helpful?
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
- 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
- The window to select a connection will come up. Click “+” next to Create New Connection
- Click the “+” next to the OLE DB (ADO) selection
- 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
- Click Next
- On the following window, you input the SQL Server information
- Set the following field with their respective information
Server: <SQL Instance Name>,<SQL Listening Port>
Database: POR
Integrated Security: checked (For Windows Authentication)
Database: POR
Integrated Security: checked (For Windows Authentication)
- Click Finish
- The OLE DB (ADO) connection should be listed and the tables should be accessible. Select the tables to read from
- Click Finish when you are done.