Thanks! I actually did play around with this option for a while.
But now I tried it again and I got it to work.
You do not have to add the sort key to the report at all. Put it in the query, select the crosstab, and then do to data -> sorting in the properties. (or data -> advanced sorting...
Hello,
I have a crosstab with a sort key for the rows. With the sort key showing, it works fine. After I "cut" the sort key out, the sorting no longer works, it just displays the rows as if there is no sort. Looking at query explorer, the sort key is still in the query.
"Cutting" the sort...
Hello,
I have two different queries in my report. Both are a count of employee, but they are from different tables. How can I calculate the sum of all employees in list A and employees in list B, i.e. have a grand total of all employees from both lists? Also, there is no relationship between...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.