Previewing Reports at a Remote Location

SQR Production Reporting Studio allows you to execute reports 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.

To preview a report at a remote location, you must be connected to Production Reporting using a remote data connection. You define the remote data connection in the Select SQR Database window in the Create Data Connection wizard.

*  To preview a report at a remote location:

  1. Make sure you are connected to Production Reporting using a remote data connection, and select Report, then Remotely Process Report.

  2. In the Remote Login dialog box, enter the requested information and click OK.

    Table 15. Remote Login Options 

    OptionDescription

    Host Server

    Production Reporting host name.

    Username

    Domain name to log into the Production Reporting host.

    Password

    Password to log into the Production Reporting host.

    Connectivity String

    Database username, database password, and database name. For example:

    scott/tiger@dbname where scott is the database user name, tiger is the database password, @ is the Oracle-specific separator, and dbname is the database name.

    Note:

    The last field changes depending on the type of database you log into (for example, Oracle or Sybase) and the database networking software running on the server (for example, SQL*Net). See step 5 under Creating a New Data Source Connection for more information.