KB11378: How to sort by a non-displayed attribute form in a Report Services document in MicroStrategy Developer

The following example, using the Strategy Tutorial project, includes the attribute Month with three forms: ID, DESC and DATE. By default, only the DESC form is in display form:

 
If users wish to sort by a non-displayed form, such as DATE, in the Report Service document, the following steps can be taken:
 

• At the base report level, go to Data > Advance Sorting, then add Month to the 'Sort By' column.
• Define the sort to be performed by DATE in the Criteria column:
  

• Save and close the report.
• Open the document editor and add the above report as a dataset.
• Press the SHIFT key while dragging and dropping the above report to the document design area.

Notice that the DATE form now becomes available for sorting:

 
KB11378