Is there a variable or a way to get the TNS name behind the Connection name?

This message has been edited. Last edited by: <Emily McAllister>,

Do you have access to the Reporting Server Console? You can look at the properties of the connection under Adapters.

You could also create a simple fex with this code in it:

SQL SQLORA ?

This message has been edited. Last edited by: BabakNYC,

Sorry for the delay in responding... thanks for getting me on the right path.

Yes I could go to the console to get the information but I wanted a way to display it to the users in a dashboard setting. The below code helped create the amper to use for displaying.

SQL SQLORA
select ora_database_name from dual;
TABLE
ON TABLE HOLD AS GETNAME
END
-RUN
-READ GETNAME &ORA_DATABASE_NAME.A4000

Worked like a charm!