Suggested Best Practices for naming your ERP Data Sources when Using Crystal Reports 2011

[TammyPowlas]

For Crystal Reports, 2011, Open SQL drivers allow you to report on SAP database (transparent) tables, and InfoSet drivers that allow you to report in InfoSets, you may have connections set up for each box.  This can get confusing and crowded under "My Connections" in Database Expert.

I recommend renaming the connections.  Follow the steps below.

First go to File > New > Blank Report or Standard Report

We will create a new connection

Double click on Make New Connection

Select desired SAP ERP system and log in

Right Click > Options and enter desired table

My example is looking for a custom table labeled ZFI_OPS%

Now you can follow the normal steps to continue creating the report.

But if you make too many connections, it gets crowded at the top under My Connections

So what I like to do is rename the connections for each type of driver – InfoSets, tables, and for each box.

Right click->Rename Connection

In my example I renamed it to Training tables