Author Topic: Display Database Environment in Report Template  (Read 507 times)

Offline abirkholz1

  • Associate
  • **
  • Posts: 2
  • Forum Citizenship: +0/-0
Display Database Environment in Report Template
« on: 03 Feb 2007 04:13:49 am »
I am trying to create a report template that will display the database environment (Oracle in this case) name at run-time.  Does anyone know how to get the database environment name displayed at run-time?

Thanks.

Offline ReportNet Addict

  • Global Moderator
  • Statesman
  • *****
  • Posts: 826
  • Forum Citizenship: +61/-40
  • Creator of the Impact Suite
    • The Impact Suite
Re: Display Database Environment in Report Template
« Reply #1 on: 04 Feb 2007 07:08:41 am »
have you looked in the Oracle forums for the available sql functions?

Offline abirkholz1

  • Associate
  • **
  • Posts: 2
  • Forum Citizenship: +0/-0
Re: Display Database Environment in Report Template
« Reply #2 on: 06 Feb 2007 01:37:19 am »
I thought there might be a default function available.  However, it is easy enough to create a query (select name from v$database;) and pass that information into the report.

Thanks.