I have long wondered this question and figured someone out there might know. I have a QML report that looks fairly simple. Even though I have a bunch of selected columns in my output, you are not able to apply sorting on all of them. In this case, I am reporting all Suppliers but the Supplier name is not available to be the default sort. What gives here?
It even shows a blank column which is strange.
ACCEPTED SOLUTION
Accepted Solutions
I think it's because those are "Objects". You can't enter specify criteria for an Object when you run the search. It can't be be sorted either. The query is finding Objects, then there's an additional step to render that as a String for the actual results.
Usually when you are reporting on an Object, you can find the underlying column you want by navigating the links. I don't have a consistent solution for Supplier Name, but you can try one of these:
- Principal.Name
- Organization.Name
I think it's because those are "Objects". You can't enter specify criteria for an Object when you run the search. It can't be be sorted either. The query is finding Objects, then there's an additional step to render that as a String for the actual results.
Usually when you are reporting on an Object, you can find the underlying column you want by navigating the links. I don't have a consistent solution for Supplier Name, but you can try one of these:
- Principal.Name
- Organization.Name
