When you print a cross table in SAS Visual Analytics to PDF, values might be sorted in a different way in the PDF file compared to in the application.

For example, you encounter this issue when you complete steps similar to the following:

1. Create a new report in SAS Visual Analytics.
2. Create a new hierarchy that includes three data items: Drive Train, Origin, and Make.
3. Create a custom sort based on Make.

Note: All values from the Make data item are listed in descending order (Volvo, Volkswagen, Toyota, and so on).

4. Add a cross table, choose the hierarchy on Rows, and leave the Frequency on Measures.
5. Expand All ► Asia to enable the cross table to appear in SAS^® Visual Analytics Designer.

Note: All data items are sorted in ascending order. However, the Make data item is sorted in descending order due to the custom sort.

SAS^® Report Viewer displays the same order.

6. Select the Print option in SAS Visual Analytics Designer. This is how the cross table is displayed in the PDF file.

Note: Values for Make are not sorted in ascending order, which means that the custom sort is not honored when printing to a PDF file.

This issue occurs only when you use both the hierarchy and the custom sort in a cross table.

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

Operating System and Release Information

A fix for this issue for SAS Visual Analytics 7.51 is available at:

A fix for this issue for SAS Visual Analytics 7.5 is available at: