Providing software solutions since 1976

• Log in
• Create profile
• Welcome
  [Log out]
• Edit profile

• Print  |
• Feedback  |
• Share

  • E-mail

  
  
  

  E-mail This Page

  Your Name:*
  Your E-mail:*
  Recipient E-mail:*
  Send a copy to me
  Personal Message:
  
  

  * indicates a required field

Overview

SAS Web Report Studio enables you to view reports that are created using SAS Enterprise Guide. The ability to publish reports to SAS Web Report Studio is not enabled by default, so this sample first shows you how to enable the publishing functionality, and then explains how to publish a simple report. Typically, enabling publishing has to be done only once.

If you are running version 4.2 (or later) of SAS Enterprise Guide, see SAS Note 40608.

As the input table for the report, this sample uses the SHOES table, which is one of the sample tables included with SAS.

Before You Begin

• This sample assumes that you have already executed a SAS program named LoadDefaultPreferences.sas, which is provided with SAS Web Report Studio. Typically, this program is executed as part of installing your SAS BI Environment. For more information, see "Installing Metadata" in the deployment.html file, located in the SAS Web Report Studio installation directory.
• Report Web services do not support trusted or Web authentication, HTTPS protocol, reverse proxies, or a clustered environment with SAS Enterprise Guide 4.2 or earlier. Support for clustered environments began with version 4.22.
• To perform the steps in this sample, you must have the ability to perform tasks in SAS^® Management Console.

Define a SAS Profile in Metadata

The SAS profile centrally stores information that all of your SAS Enterprise Guide installations need in order to interact with your SAS Web Report Studio installation.

1. In SAS Management Console, expand Foundation Services Manager and navigate down to Platform User Service.

   

2. Right-click on Platform User Service and select Properties.
3. Click the Service Configuration tab.



4. Click Edit Configuration to open the User Service Configuration dialog box.
5. Click the Profiles tab.



6. A profile named global should already exist. Select it and click Edit.
7. Copy the information in the Domain URL field and then click OK. (You will paste the copied URL in step 8b.)
8. Back in the User Service Configuration dialog box, click Add to open the New Profile dialog box, and complete the following fields:
1. In the Application field, type SAS.

SAS must be all uppercase.

2. In the Domain URL field, paste the URL that you copied from the global profile.
3. In the Class field, type com.sas.preferences.SASProfile.



9. Click OK until you have exited all of the dialog boxes.

Create a Definition File

The definitions file contains the values that will be used as input to the configureReportWebServicesScripts script.

1. Use a text editor to create a new file named definitions.txt in the SAS Web Report Studio installation directory. On Windows, this location is typically C:\Program Files\SAS\SASWebReportStudio\3.1.
2. In the file, enter the following information:
• the name of the machine where SAS Web Report Studio is deployed
• the listening port for the Web application container (in this sample, 8080 is used for Tomcat)

Note: The default port for WebLogic is 7001. The default port for WebSphere is 9080.

• the URL root, which should always be SASWebReportStudio.

In this sample, the definitions.txt file contains the following content:

$WRS_URL_MACHINE$=abc.corp.com $WRS_URL_PORT$=8080 $WRS_URL_ROOT$=SASWebReportStudio

Use the Definition File to Enable Report Services

1. Ensure that your Web application container (Tomcat, WebLogic, or WebSphere) is running and that you can access the SAS Web Report Studio logon screen.
2. Open a command prompt window and navigate to the SAS Web Report Studio installation directory.
3. Execute configureReportWebServicesScripts by specifying the definitions.txt file that you created previously.



Below is the output from a successfully executed script. The script creates another script named enableReportWebServices.

In the output, double check that the name of the definitions.txt file is spelled correctly. If it is not, then correct the spelling error and execute the script again.



4. Execute enableReportWebServices. Below is the output from a successfully executed script.



If you see the error Exception::(401) Unauthorized, follow the instructions in SAS Note 32022. If you see a NullPointerException, follow the instructions in SAS Note 32240.

5. Close the command prompt window.
6. Open enableReportWebServices in a text editor.
7. The last line contains a URL in the form http://<machine name>:<port>/SASWebReportStudio/servlet/AxisServlet. Submit this URL in your browser. It should take you to a valid Web page with three services listed: Admin, Version, and ReportRepositoryWebService.

If the URL is not valid, then there is likely an incorrect value in your definitions.txt file.

8. Restart your Web application container (Tomcat, WebLogic, or WebSphere).
9. Log on and then off SAS Web Report Studio by using the URL that includes the machine name. For example, http://abc.corp.com:8080/SASWebReportStudio.

You must log on and off at least once before attempting to publish a report. You cannot use localhost for this step.

Publish Your Report in SAS Enterprise Guide

1. In SAS Enterprise Guide, create the report that you want to publish, or use an existing report. The Result Format must be SAS Report. This sample creates a simple list report based on the SHOES table.
2. In the Project Designer, right-click on the SAS Report icon and select Publish to launch the Publishing wizard.



3. Select Report Repository and click Refresh to populate the field with your SAS Web Report Studio URL. Click Next.

If you see an error message that publishing is not enabled, refer to the instructions in SAS Note 18324.

4. Name the report. In this sample, the report is named Sales of Shoes in 2007. The Location cannot be edited. The output is automatically saved in the folder that is required by SAS Web Report Studio. This sample also includes three optional keywords. You can use keywords as search criteria in SAS Web Report Studio. Click Next.



5. On this wizard page, for this sample, your only option is to accept that the report will be a snapshot of the results that you generated by using SAS Enterprise Guide. This means that you will not be able to refresh the data in SAS Web Report Studio.



If your SAS Report is the output from a stored process, then Data can be refreshed after the report is published is available. Because stored processes are stored on a central server, they can be accessed by multiple clients, including SAS Web Report Studio. If you select this option, then reports that are created from a stored process can be refreshed from SAS Web Report Studio. The third option, Data can be refreshed for only portions of the published report, is available for SAS Reports that contain output from both stored processes and tasks. You can refresh the content that is generated by the stored process, but you cannot refresh the content that is generated by the task.

6. Click Finish.

View the Report in SAS Web Report Studio

To see how the report looks in SAS Web Report Studio, click the Results tab at the top of this sample.

Additional Documentation

For instructions for enabling Report Web services, see the deployment.html file, located in the SAS Web Report Studio installation directory.

For a list of available documentation for SAS Web Report Studio, see http://support.sas.com/documentation/onlinedoc/wrs/index.html

For a list of available documentation for SAS Enterprise Guide, see http://support.sas.com/documentation/onlinedoc/guide/

---

These sample files and code examples are provided by SAS Institute Inc. "as is" without warranty of any kind, either express or implied, including but not limited to the implied warranties of merchantability and fitness for a particular purpose. Recipients acknowledge and agree that SAS Institute shall not be liable for any damages whatsoever arising out of their use of this material. In addition, SAS Institute will provide no support for the materials contained herein.

---

These sample files and code examples are provided by SAS Institute Inc. "as is" without warranty of any kind, either express or implied, including but not limited to the implied warranties of merchantability and fitness for a particular purpose. Recipients acknowledge and agree that SAS Institute shall not be liable for any damages whatsoever arising out of their use of this material. In addition, SAS Institute will provide no support for the materials contained herein.

View Your Published Report in SAS Web Report Studio

1. In SAS Web Report Studio, select Report > Open.
2. The published report should be in the shared Reports folder location. In this sample, the report is named Sales of Shoes in 2007. Notice that the keywords that were entered in the Publishing wizard are displayed with the report.



3. Select the report to view it. The style selected on the Format tab in the Report Properties dialog box is applied automatically. This sample uses the Seaside style.



4. Click Edit to see how the report looks in edit mode. Notice that you cannot modify the report in any way. To refresh the data, you must rerun the report in SAS Enterprise Guide and then republish the results to SAS Web Report Studio.

Operating System and Release Information