[RS] Display connection-details / database from within Report Studio

[blom0344]

Is there a way to quickly check the database connection from within Report Studio? With a great many framework and multiple testenvironments it is often difficult to find against which source a report is running..

[COGNOiSe administrator]

You could embed a calculation in your models which would have to be adjusted between environments.

[blom0344]

You could embed a calculation in your models which would have to be adjusted between environments.

Perhaps a little explanation. I was used to display the connection properties in a lone cell in BO reports using a set of report functions that allow to display connection and database details. The idea was to give testers direct insight into which database data was coming from.
I was hoping to be able to find something in Report Studio along similar lines.

Actually the same goes for displaying the full SQL statement - in rare cases - as a string within the report. Not for production reports, but sometimes handy for special reports used in conversion projects (i.e. checking purposes)

[COGNOiSe administrator]

Well, I didn't want to go there, but it seems that you are eager to roll up your sleeves and get dirty ...  :D

You can get at any ReportNet component, even the tiniest one, like datasource connection properties, using XML. So by extension, if you were to employ the services of AJAX, you would be able to get that kind of information in RS. Full understanding of Cognos XML/SOAP/SDK is a must.