cancel
Showing results for 
Search instead for 
Did you mean: 

Getting database and server info onto Crystal Reports

Former Member
0 Kudos

Hi There

I ran this query in Query Builder to show me all Crystal Report

SELECT * FROM CI_INFOOBJECTS WHERE SI_KIND = 'CrystalReport'

and found the information I need is held by SI_USER, SI_SERVER and SI_DB properties. Any idea on how to extract just these 3 properties?

I tried selecting these 3 properties but I get no data back.

Please advise.

Many Thanks

Bola

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

I am looking for the same answer to Bola's question.  I don't understand the 1st response above and how using CR2008 would help in this matter.  Any help is greatly appreciated.

DellSC
Active Contributor
0 Kudos

There is no way to get this info from the CMS using Crystal Reports.  You'll have to use one of the SDKs to get this information.  Please ask this in one of these spaces:

.Net: http://scn.sap.com/community/bi-platform/microsoft-net-sdk

Java: http://scn.sap.com/community/bi-platform/java-sdk.

-Dell

Former Member
0 Kudos

Actually, I just found on another post on here that it is possible if you are using a recent enough version of BOE!

Select SI_NAME, SI_PROCESSINFO From CI_INFOOBJECTS Where SI_INSTANCE=0 And SI_PROCESSINFO.SI_LOGON_INFO.SI_LOGON1.SI_SERVER='xxxxxxxxx'

DellSC
Active Contributor
0 Kudos

And are you doing this through Crystal or in the QueryBuilder?

-Dell

Former Member
0 Kudos

The Query Builder

Former Member
0 Kudos

Hi Joe,

Back in Septenber, I got this from one of the SAP engineers. Note that I haven't tried this solution so not sure if it works.  Let us know how it goes.

"

Hi Bola,

Try using below formula and check if it helps:

=Connection("query_name")

OR

=Connection(DataProvider(<obj>))

<obj> could be any object from the query. DataProvider(<obj>) will provide the query name to Connection function.

This will give detail on middleware and Database used.

Hope it will help.

Regards,

Yuvraj

"

0 Kudos

CR 2008 may have this ability