Display Server & Databsource

[Montana751]

Crystal XIr2 Oracle database
I have many servers and databases from which reports are run and I would like to have the server name and database information from where the report was generated to display on the report.

Anyone have an ideas how to do this?

 

[briangriffin]

Use a SQL Expression to call the Oracle Sys_Context function. You would then pass in various parameters to return the information you're looking for. For example:

SYS_CONTEXT ('userenv','server_host')

returns the server name.

SYS_CONTEXT ('userenv',instance_name')

returns the current instance.

There are lots of parameter values that you can use - google sys_context to find a complete listing.

 

[Montana751]

Thanks for the info, worked perfectly.