Adding Database Name to Report Header 2

[jwrjwr54]

I'm using CR XI with an ODBC Oracle connection.

Is there a way to add the Oracle Database name to the RH? For example, I have 3 Oracle databases (ERDDEV, ERDTEST, and ERDPROD). I would like to add 'Data Source:' and a field that would automatically update when I change datasource locations.

Many thanks

 

[briangriffin]

I don't have an Oracle db handy to test, but you can create a SQL expression to do this. In SQL Server it would be:

select db_name()

For Oracle, try:

select * from global_name

 

[Madawc]

briangriffin, could you please expand on your solution in SQL? It would be very useful to have in Crystal, but when I try it, it gets rejected in both SQL Expression and SQL Command. I have Crystal 11.5.

Madawc Williams (East Anglia, UK). Using Crystal 10 & 11.5 with Windows XP

 

[IanWaterman]

Its works for SQL 2008 and CR 10

Created SQL exp

%DB Name
(select db_name())

All OK.

Ian

 

[fisheromacse]

works nicely in CR XI.0

and will be useful.

thanks!

 

[Madawc]

A useful trick. I got it working as just

(select db_name())

I'd suppose that %DB Name is the field name

Madawc Williams (East Anglia, UK). Using Crystal 10 & 11.5 with Windows XP