SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 40621: Column values might wrap or display vertically when displaying UTF-8-encoded data in SAS® Web Report Studio

DetailsHotfixAboutRate It

Overview

When displaying a SAS Web Report Studio report that contains UTF-8-encoded data, columns might wrap or values might display vertically. To circumvent this problem, resize the column by using the drag-and-drop method until the values are not wrapped.

Select the Hot Fix tab in this note to access the hot fix for this issue.

This SAS Note contains the following topics:

Table of wrapping properties

After applying the hot fix, you can set the following properties in order to control wrapping. The properties are listed as you would enter them using the Configuration Manager plug-in to SAS® Management Console. For information about how to specify the properties in the LocalProperties.xml file, see

Goal Setting
You want to use the default wrapping method, which enables you to manually resize columns based on blank spaces in column labels. If you want the default wrapping, then you do not need to set any property. However, setting the following properties to normal is equivalent to using the default wrapping:
.vmwide.sas.report.model.table.nowrap
.vmwide.sas.report.model.table.wordbreak
You do not want columns to wrap for any locale, regardless of any blank spaces in the column labels. Set the .vmwide.sas.report.model.table.nowrap property to force.

Note: Setting .vmwide.sas.report.model.table.nowrap to force can cause SAS Web Report Studio to print blank tables. For more information, see SAS Note 59559.

You do not want columns to wrap for the locales listed for the .vmwide.sas.report.model.table.nowrap.locales property, regardless of any blank spaces in the column labels.

Locales that are not specified in the .vmwide.sas.report.model.table.nowrap.locales property use the default method for column wrapping.

Set the .vmwide.sas.report.model.table.nowrap property to locale and set the .vmwide.sas.report.model.table.nowrap.locales property to one or more two-letter codes for the appropriate locales. Separate codes with commas.
(Available only for Internet Explorer.) You want all columns to wrap at any character for any locale, regardless of any blank spaces in the column labels. Set the .vmwide.sas.report.model.table.wordbreak property to force
(Available only for Internet Explorer.) You want all columns to wrap at any character for the locales listed for the .vmwide.sas.report.model.table.wordbreak.locales property, regardless of any blank spaces in the column labels.

Locales that are not specified in the .vmwide.sas.report.model.table.wordbreak.locales property use the default method for column wrapping.

Set the .vmwide.sas.report.model.table.wordbreak property to locale and set the .vmwide.sas.report.model.table.wordbreak.locales property to one or more two-letter codes for the appropriate locales. Separate codes with commas.

How to set properties using the Configuration Manager plug-in

In this example, columns do not wrap for any locale, regardless of any characters such as blank spaces.

  1. In SAS® Management Console, select Application Management ► Configuration Manager ► SAS Application Infrastructure.
  2. Right-click Web Report Studio 4.x, and select Properties.
  3. In the Properties dialog box, click the Advanced tab.
  4. Click Add to open the Define New Property dialog box.
    1. For the Property Name, enter .vmwide.sas.report.model.table.nowrap
    2. For the Property Value, enter force
  5. Click OK twice to exit both dialog boxes and save the changes.
  6. Restart your web application server to enforce the new setting.

How to set properties using the LocalProperties.xml file

In the following example, columns do not wrap for Japanese, Chinese, or Korean locales. Columns do wrap normally for all other locales. Notice that vmwide portion of the property values shown in the previous table is entered as its own attribute in the LocalProperties.xml file.

<!-- values: normal, force, locale -->
<sas.report.model.table.nowrap vmwide="true">
  locale
</sas.report.model.table.nowrap>


<!-- locales: use 2-letter language prefix only -->
<sas.report.model.table.nowrap.locales vmwide="true">
   ja,zh,ch,ko
</sas.report.model.table.nowrap.locales>

Restart your web application server in order to enforce the changes.

Note: If you do not have a LocalProperties.xml file, see SAS Note 32858.



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Web Report Studioz/OS4.2_M24.39.2 TS2M39.2 TS2M3
Microsoft® Windows® for x644.2_M24.39.2 TS2M39.2 TS2M3
Microsoft Windows Server 2003 Datacenter Edition4.2_M24.39.2 TS2M39.2 TS2M3
Microsoft Windows Server 2003 Enterprise Edition4.2_M24.39.2 TS2M39.2 TS2M3
Microsoft Windows Server 2003 Standard Edition4.2_M24.39.2 TS2M39.2 TS2M3
Microsoft Windows Server 2003 for x644.2_M24.39.2 TS2M39.2 TS2M3
Microsoft Windows Server 20084.2_M24.39.2 TS2M39.2 TS2M3
Microsoft Windows Server 2008 for x644.2_M24.39.2 TS2M39.2 TS2M3
Microsoft Windows XP Professional4.2_M24.39.2 TS2M39.2 TS2M3
Windows 7 Enterprise 32 bit4.2_M24.39.2 TS2M39.2 TS2M3
Windows 7 Enterprise x644.2_M24.39.2 TS2M39.2 TS2M3
Windows 7 Home Premium 32 bit4.2_M24.39.2 TS2M39.2 TS2M3
Windows 7 Home Premium x644.2_M24.39.2 TS2M39.2 TS2M3
Windows 7 Professional 32 bit4.2_M24.39.2 TS2M39.2 TS2M3
Windows 7 Professional x644.2_M24.39.2 TS2M39.2 TS2M3
Windows 7 Ultimate 32 bit4.2_M24.39.2 TS2M39.2 TS2M3
Windows 7 Ultimate x644.2_M24.39.2 TS2M39.2 TS2M3
Windows Vista4.2_M24.39.2 TS2M39.2 TS2M3
Windows Vista for x644.2_M24.39.2 TS2M39.2 TS2M3
64-bit Enabled AIX4.2_M24.39.2 TS2M39.2 TS2M3
64-bit Enabled Solaris4.2_M24.39.2 TS2M39.2 TS2M3
HP-UX IPF4.2_M24.39.2 TS2M39.2 TS2M3
Linux for x644.2_M24.39.2 TS2M39.2 TS2M3
Solaris for x644.2_M24.39.2 TS2M39.2 TS2M3
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.