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

In SAS Web Report Studio, if a table has more columns and rows than the currently set maximums, then scrolling is enabled. You can change the maximum number of columns and rows to display at one time at the report level by using the Table Properties dialog box. You also can change these settings globally for all users, as explained in this SAS Note.

Version 3.1

In version 3.1, open your LocalProperties.xml file in a text editor. (If you do not have a LocalProperties.xml file, see SAS Note 32858.)

Enter your preferred values for the following properties. If these properties are not currently in your LocalProperties.xml file, then you can add them. Properties for displaying columns and rows in the Preview Data window are also included.

<!--  The following section defines the DEFAULT number of visible table   -- >
<!--  rows & columns when creating a new report.  The actual number can   --> 
<!--  be set on a table-by-table basis in "table properties".  --> 

  <com.sas.apps.citation.util.userpreferences>
    <previewDataMaxRows>100</previewDataMaxRows> 
    <previewDataMaxCols>-1/<previewDataMaxCols>  <!-- system max substituted --> 
    <viewReportMaxRows>100/<viewReportMaxRows> 
    <viewReportMaxCols>-1/<viewReportMaxCols>    <!-- system max substituted --> 
  </com.sas.apps.citation.util.userpreferences>

<!--  The following are system-wide absolute maximum table (view) sizes,  --> 
<!--  reports requesting larger sizes, or "entire table", are limited    --> 
<!--  to these values.  System-wide memory could be compromised if these --> 
<!--  are raised arbitrarily high.                                       --> 

  <com.sas.apps.citation.util.userpreferences>
    <absoluteMaxVisibleRows>1000</absoluteMaxVisibleRows> 
    <absoluteMaxVisibleCols>150</absoluteMaxVisibleCols> 
  </com.sas.apps.citation.util.userpreferences>

When you are done, restart your Web application server.

Versions 4.2 and 4.3

In versions 4.2 and 4.3, use SAS Management Console to change the column and row properties.

1. Navigate to Application Management ► Configuration Manager ► Web Report Studio 4.x.
2. Right-click on Web Report Studio 4.x and select Properties.
3. Click the Advanced tab.
4. For each property that you want to set, click the Add button and enter the Property Name and Property Value. The property names are:

com.sas.apps.citation.util.userpreferences.absoluteMaxVisibleRows 
com.sas.apps.citation.util.userpreferences.absoluteMaxVisibleCols 
com.sas.apps.citation.util.userpreferences.previewDataMaxRows 
com.sas.apps.citation.util.userpreferences.previewDataMaxCols 
com.sas.apps.citation.util.userpreferences.viewReportMaxRows 
com.sas.apps.citation.util.userpreferences.viewReportMaxCols 

5. When you are done, restart your Web application server.

Here is an example:

Note: Property names that are more than 60 characters will only display up to 60 characters when you reopen the Advanced tab. For example, com.sas.apps.citation.util.userpreferences.absoluteMaxVisibleCols displays as com.sas.apps.citation.util.userpreferences.absoluteMaxVisibl However, the property setting is still applied.

Operating System and Release Information