Is there a way to display data source properties inside a crystal report?

[Former Member]

We have Crystal reports developed over SAP ECC data. The reports connect to an Infoset and work just fine. We would like to display in the heading of the report, which SAP environment (DEV, QAS, or PRD) the report is connected to, as a visual safeguard to make sure that the users are not accidentally running a report over DEV or QAS thinking it is PRD data.

Is there a way to display the data source properties that I can see under the Database Expert, inside the crystal report? Specifically, I'm looking for Client, Database, or Server.

[Former Member · Accepted solution]

i use this in sql sp or a command in crystal to retrieve the database name

DB_Name()

you can then create a formula to display what you want the end use to see

[Former Member · Accepted solution]

Can you add a command when connecting to an SAP environment? I have added commands before, but am unable to add one with a connection to SAP ECC.

[Former Member · Accepted solution]

i dont believe so. cant find anything on the web. can you add it to your bex query in sap and pull it as a field?