Skip to Content
Author's profile photo Tammy Powlas

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

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

Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.