Skip to Content

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

/wp-content/uploads/2012/08/1figcr_130208.png

We will create a new connection

/wp-content/uploads/2012/08/2fig_130209.png

Double click on Make New Connection

/wp-content/uploads/2012/08/3fig_130210.png

Select desired SAP ERP system and log in

/wp-content/uploads/2012/08/4fig_130211.png

Right Click > Options and enter desired table

/wp-content/uploads/2012/08/5fig_130212.png

My example is looking for a custom table labeled ZFI_OPS%

/wp-content/uploads/2012/08/6fig_130213.png

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.

/wp-content/uploads/2012/08/8fig_130214.png

Right click->Rename Connection

/wp-content/uploads/2012/08/9fig_130215.png

In my example I renamed it to Training tables

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply