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

One of major new features in SAS Web Report Studio 4.2 is the ability to link to different sections in a report. You can link to sections within the same report or within another report. This sample explains how you can use this feature to create a custom table of contents that links to individual sections.

About the sample data and report

The data source used in this sample is the SASHELP.PRDSALE table, which is shipped with SAS. The table is used as the data source for an information map. The information map is used to create a three-section report. Each section has a filter applied that displays information only for a specific country.

Assumptions

In order to follow along with this sample, you must have the following tasks already completed:

• The PRDSALE table is registered in metadata.
• You have created an information map with the data items from PRDSALE.
• You have a three-section report that is based on the PRDSALE information map. Each section has a filter for a specific country. The sections are named something like: Germany Sales for Qtr, Canada Sales for Qtr, and U.S.A. Sales for Qtr.

Create a data item for each report section

Besides the data items that are already included with the PRDSALE table, you must create a new data item for each section of your report.

1. In SAS^® Information Map Studio, open the information map that includes the data items from PRDSALE.
2. Select Insert ► New Data Item.
3. In the Data item name box, type Section 1.
4. Under Expression settings, click Edit.
5. For Type, select Character.
6. In the Expression Text box, enter the following expression, and then click OK to return to the Properties dialog box.

case when <<PRDSALE.COUNTRY>> = 'GERMANY' then 'Germany Sales for Current Quarter' else ' ' end

7. Select Classifications, Aggregations, Formats. In the Formats section, for the Valid width range option, enter 50.
8. Select Value-Generation Method, and then select User selects values from a dynamic list.
9. Click OK to exit the Properties dialog box.
10. Repeat steps 2 through 9 to create two more data items, named Section 2 and Section 3. When entering the case expression, edit the expression so that one data item filters for CANADA and the other data item filters for U.S.A.

    When you are done, your information map should look something like this:

    

11. Save the information map.

Create a report section for the custom table of contents

1. Open the three-section SAS Web Report Studio report that is based on the previously discussed information map. Recall that each section has a filter for a specific country. In this sample, the sections are named Germany Sales for Qtr, Canada Sales for Qtr, and U.S.A. Sales for Qtr.
2. In Edit mode, select Insert ► New Section. Name the section Table of Contents, and leave the Get new data option selected. Click OK.
3. In the Table of Contents panel on the left, select Options ► Reorder Sections. Move the new section up in the list so that it is the first section in the report.



4. With the Table of Contents section displayed, select Data ► Select Data.
5. Select the PRDSALE information map that contains the Section 1, Section 2, and Section 3 data items. Add just those data items to the section.
6. Insert three list table objects into the layout. You will need to add a row to the layout grid using the third icon on the vertical toolbar.
7. Reassign data items in each table as described next:
• Right-click on the first table object and select Assign Data, and then hide all data items except Section 1.
• Right-click on the second table object and select Assign Data, and then hide all data items except Section 2.
• Right-click on the third table object and select Assign Data, and then hide all data items except Section 3.



8. Right-click on the first table object and select Filter and Rank.
9. Select Filter and Get Values.
10. Move the available value over to the Selected values box.



11. Repeat the steps 8 through 10 to add the corresponding filter to the other two table objects. For example, the second table might have the Canada filter and the third table might have the U.S.A. filter.

Link each table to the corresponding section in the report

1. Right-click on the first table and select Report Linking.
2. Select the Include report links in the table option.
3. Select the An existing report option.
4. Select the report that contains the three sections.
5. Click Set Up Destination Report.
6. Beside the Open to section prompt, select the section of the report you want to link to, as shown in the following example.



7. Repeat steps 1 through 6 to link each table to its corresponding section.

Results

The Table of Contents section should now appear something like this.

Tip: In this sample, the Applied Filters box, which appears by default above each table, is hidden. To hide the Applied filters box, select View ► Applied Filters so that the check mark next to the Applied Filters option is removed.

Additional Documentation

For more information about SAS Web Report Studio, see the SAS Web Report Studio documentation page.

For more information about SAS Information Map Studio, see the SAS Information Map Studio documentation page.

---

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.

Operating System and Release Information