Using the Page Properties Report Sort option, can I sort on 2 fields?

[Chris Freeman]

I figure this may be a limit on functionality, or maybe I just don't have the proper syntax, but I have a PPR that displays Title, Phase, and Status. I want to sort by Phase, then Title. I tried Phase, Title. I tried Phase|Title, (Phase ASC, Title ASC) and nothing works.

Is this possible?

[Andrey Khaneev _StiltSoft_ · Accepted solution]

Hi Chris,

You can use Table Filter macro to sort on multiple fields.

[Chris Freeman]

Andrey, thanks, and yes, I would use Table Filter...if they had it. I have submitted a request for this. Once installed, does Table Filter allow you to set a fixed default? So every time a user visits the page, they see the set filter the way I want them to? Even if they can refilter and sort on their own, if they refresh the page, will it snap back to the filter settings I create as default for the page?

[Andrey Khaneev _StiltSoft_]

Yes, that's exactly how it works: on page load it applies default filters and sorting.

[Chris Freeman]

OK, great! Thanks for the info.

[James Dellow · Accepted solution]

No, it is not the syntax - the out of the box macro only sorts by one column.