Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Report Studio => Topic started by: abirkholz1 on 02 Feb 2007 04:13:49 PM

Title: Display Database Environment in Report Template
Post by: abirkholz1 on 02 Feb 2007 04:13:49 PM
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.
Title: Re: Display Database Environment in Report Template
Post by: sir_jeroen on 03 Feb 2007 07:08:41 PM
have you looked in the Oracle forums for the available sql functions?
Title: Re: Display Database Environment in Report Template
Post by: abirkholz1 on 05 Feb 2007 01:37:19 PM
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.
Text only | Text with Images