BI Tools

Tips and tricks for building information maps, OLAP cubes, reports, and dashboards

BI Admin

Learn your way around a SAS BI installation.

Visual Analytics

Learn your way around the SAS Visual Analytics tool

Coding & Data

Extract, transform, and load your data into the SAS BI toolset

Stored Processes

Create and design stored processes like a rock star

Home » BI Tools

Web Report Studio: Switch Report Sections to Tabs in a Snap!

Submitted by on 2013-05-28 – 7:18 AM 5 Comments

One of my gripes with Web Report Studio is that it is not always obvious that a report contains more sections. When demonstrating a report with sections, I find myself placing extra emphasis on the feature to ensure the user understands how it works.  Recently, Amit Kumar Pattnaik, a SAS BI manager, asked if I knew of a way to change the section so they were more obvious, such as how it worked in SAS 9.1.3.  Turns out a quick tweak makes all the difference.

Different Ways to Display Sections

In the days of SAS Web Report Studio 9.1.3, the tool worked differently and the section names would appear horizontally across the top of the report.  In subsequent releases, Web Report Studio underwent a redesign.  

The sections are located within the Table of Contents drop-down (Before). But if you move the sections to tabs (After) it makes it more obvious that additional information is available. It was easy to miss the Table of Contents content before – but not now.

 web report studio add tabs

Adding Sections

web report studio sections

You can add as many sections as you want to your reports.  Each section is  treated as a different report – meaning that you can use different data sources and have different content and layout. From the Edit tab, click the Options drop-down at the end of the Table of Contents to see all of the section actions.   

From this drop-down menu, you can perform several operations on your sections.  All of these make it easier for the user to navigate your report.  For instance, if you have several sections, you may want to group the like ones together using the Reorder Sections.  If the section names become to long, just use the Rename Sections to create a more concise name. 

How To Change Your Web Report Studio Configuration

To change the section to tabs, you can make a simple adjustment to your SAS Web Report Studio configuration in Management Console. In past posts, you have seen other ways to make changes to your configuration.  For instance, if you want to create your own style, add a global footer, or control the banner at the top of the report.  

When you make a change to the configuration, you need to have access to SAS Management Console and the necessary permissions.  If you are unsure or need guidance, contact your SAS system administrator.  Before making this change – note that all reports will use this method after implementation.  In other words – lil’ Bossy Pants make sure its what everyone wants.

Note: I’m using SAS 9.3.

  1. Open SAS Management Console and navigate to Application Management> Configuration Manager > SAS Application Infrastructure.
  2. Right-click Web Report Studio 4.3 and select Properties.
  3. From the Advanced tab, click the Add button to insert a new property.
    1. In the Property Name field, type wrs.sections.tabs
    2. In the Property Value field, type true
    3. Click Ok to return to the Properties menu.

      Note: Ensure that your property matches this figure – exactly.  
      If you misspell this property -you guessed it – your report will not look different.

  4. web report studio tabs management consoleClick Ok to exit the window.
  5. Restart your web service, which is JBoss for me.
  6. Then check out your new reports.  If you don’t like the change – just return to the Properties window and change the value to false. 

Other Changes

You can use the other report features such as group breaks, section filters, and report linking to make your report more robust.  

Learn all about SAS BI

You can learn more about SAS Business Intelligence from the "SAS BI Bible." Take a peek inside the Building Business Intelligience with SAS book.

The following two tabs change content below.

Tricia Aanderud

Director of Data Visualization at Zencos Consulting
Tricia Aanderud is a SAS Business Intelligence and Visual Analytics consultant based in Raleigh, NC who works for Zencos Consulting. She has written several books about SAS, presented papers at many SAS conferences, and has been using SAS since 2001. Contact her for assistance with your next project.

Tags: , ,

5 Comments »

  • Wow … you are into some advanced stuff.

    I doubt if the stored process can call the individual WRS sections simply because you don’t have any way to reference/call/link the section name.

    However, I’ve never tried to do this task so you might want to discuss it with SAS Tech Support to see if they have a tricky idea.

    Please let me know if you do talk to anyone as well as any other tips you discover in your journey!

    Tricia

  • Prashant says:

    Hi Tricia/Angela,

    I have a Stored process feeding an Information Map which inturn is used as a Data source for a Web Report Studio. The Stored process has prompts which are diaplyed on the WRS Report This Works fine.

    Now i need to add another section to this WRS Report and source it from another Information Map which also is fed by the same Stored Process Code.Basically The Second Section Report has the Same prompts but needs to run off a different Query which i plan to incorporate in the Same Stored Process using Conditional logic.This Conditional Logic i plan to achieve using a New Prompt on the Stored Process which would Prompt the user to select values : Report1,Report2.The User basically enters the default Prompts ( common to both Reports) and then chooses Either Report1 or Report2 using this new Prompt.

    Now my question is whether it possible for the user to see Section1 directly when he chooses Prompt value of Report1 and Section2 directly when he chosses Prompt value of Report2 In the Web Report Studio .

    Any Ideas ? Please let me know. Thanks,

  • Thanks for sharing! Great to know this feature is still available via a property setting.

  • Thanks for the suggestion kind sir!

  • Amit Kumar Pattnaik says:

    That was really cool!