This is an old revision of the document!
Table of Contents
Configuring Crystal Reports for Versago and Bizweaver
SQL Server
When designing a Crystal Report that will use a SQL Server database as its data source, the report connection type must be OLE DB (ADO). This connection type has three options for the data provider: SQL Native Client, Microsoft OLE DB Driver for SQL Server, and Microsoft OLE DB Provider for SQL Server. Any of these options should work with Versago.
If you have problems with one provider (e.g. being requested for login information at runtime), try one of the others to see if that resolves the issue.
HANA
When designing a Crystal Report that will us a HANA database as its data source, the report connection type be ODBC (RDO). This document explains how to configure this type of connection for use with HANA. Two options are described in the document. Be sure to use the B1CRHPROXY32 option. Here is a sample connection string to use as a starting point.
DRIVER={B1CRHPROXY32};SERVERNODE=<YourServer>:30015;DATABASE=<YourDB>
Replace <YourServer> and <YourDB> (without the < > symbols) with the appropriate values.
Information about installing the needed HANA driver is found here.
