Queries on Matrix Control
I had developed some reports using Matrix Control. The report came well.
The reason we go for Matrix reports are to have dynamic rows and columns. I have few requirements/doubts on Matrix Control...
Lets have an example here...
I have report, row section grouped by "Level", "sub-level" & "count(employees)". Column section i have "Roles" and In detail section i have "sum(salary)".
1. I want to have header for all the columns (Level,sub-level, count). Is it possible?
2. I want interactive sort on all the above columns. (If first question is possible then this is also possible)
3. When i use "Subtotal" for the column "Level", then the bottom of the report, RS have a overall total for "sum(salary)". But i want the "sum(count)" as well along with "sum(salary)". Is it possible?
Please answer, if anyone knows?
Thanks in advance!:)