Remote Login

SQR Production Reporting Studio allows you to execute a report on a remote Production Reporting server. When you use a remote Production Reporting server, you can preview your reports in a remote test environment, and you may be able to take advantage of more powerful platforms.

Note:

The database's location does not affect the Remote Login. Remote Login is only concerned with the Production Reporting engine's location.

To preview a report at a remote location, set your local database to remote and select the desired Production Reporting database on the Data Connection - Local Database page of the Create Database Connection wizard. Then, choose Report, then Remote Preview from the menu at the top of the Layout window. The Remote Login dialog box appears. You can also access the Remote Login dialog box by choosing File, then Remote Login at report startup.

Field	Description
Host Server	Host name of the server. This is the host name of the machine where the remote Production Reporting server is located.
Username	OS (Server) user name. This is the username for the machine where the remote Production Reporting server is located.
Password	OS (Server) password. This is the password used to access the machine where the remote Production Reporting server is located.
Connectivity	Connectivity string to connect to the database. (If you do not need a database connection, enter “/” and run the report with the –xl flag.) DB2 Ssname/SQLid is the subsystem name and SQL authorization id to use. Informix Database is the name of the database to use. Oracle [Username]/[Password[@Database]] is your user name and password for the database. Optionally, you can specify the connection string for the database. Sybase Username/[Password] is your user name and password for the database. SQL Server Data_Source_Name/[Username]/[Password] is the name you give to the ODBC driver when you set up the driver, your user name, and the password for the database.