In SAS^® Web Report Studio, measure values in a crosstabulation table might not correctly render an applied comma format. This problem can occur if the measure's aggregation statistic is COUNT(argument).

As a workaround, you can create a new data item in the information map that is based on the business data, and then add that data item to the section query in the report. The following example explains how you would use this workaround for a measure named measure_it.

1. In SAS^® Information Map Studio, select Insert ► Data Item.
2. Name the new data item new_measure_it.
3. Click Edit to open the Expression Editor dialog box.
4. Click the Data Sources tab.
5. Expand the Business Data tree, and select measure_it.
6. Click Add to Expression and click OK to return to the Data Item Properties dialog box.
7. Click the Classifications/Formats tab.
8. For the aggregation, select Defined in expression.
9. In the Formatting section, assign the format COMMA18.
10. Save the information map.
11. In SAS Web Report Studio, open the affected report.
12. In the Edit view, click Select data and add the new data item new_measure_it to the section query.
13. Deselect the Add new data items to existing tables automatically option.
14. Click OK and then view the report. The comma should now appear correctly.

Operating System and Release Information

Product Family	Product	System	Product Release		SAS Release
			Reported	Fixed*	Reported	Fixed*
SAS System	SAS Web Report Studio	Microsoft® Windows® for x64	4.2	4.2_M2	9.2 TS2M0	9.2 TS2M3
		Microsoft Windows Server 2003 Datacenter Edition	4.2	4.2_M2	9.2 TS2M0	9.2 TS2M3
		Microsoft Windows Server 2003 Enterprise Edition	4.2	4.2_M2	9.2 TS2M0	9.2 TS2M3
		Microsoft Windows Server 2003 Standard Edition	4.2	4.2_M2	9.2 TS2M0	9.2 TS2M3
		Microsoft Windows XP Professional	4.2	4.2_M2	9.2 TS2M0	9.2 TS2M3
		Windows Vista	4.2	4.2_M2	9.2 TS2M0	9.2 TS2M3
		64-bit Enabled AIX	4.2	4.2_M2	9.2 TS2M0	9.2 TS2M3
		64-bit Enabled Solaris	4.2	4.2_M2	9.2 TS2M0	9.2 TS2M3
		HP-UX IPF	4.2	4.2_M2	9.2 TS2M0	9.2 TS2M3
		Linux	4.2	4.2_M2	9.2 TS2M0	9.2 TS2M3
		Linux for x64	4.2	4.2_M2	9.2 TS2M0	9.2 TS2M3
		Solaris for x64	4.2	4.2_M2	9.2 TS2M0	9.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.

---

In SAS Web Report Studio, measure values in a crosstabulation table might not correctly render an applied comma format. This problem can occur if the measure's aggregation statistic is COUNT(argument).

Type:	Problem Note
Priority:	medium
Topic:	Query and Reporting ==> Interactive Querying Query and Reporting

Date Modified:	2009-03-31 14:09:15
Date Created:	2009-03-26 14:54:56