Last post Jun 08, 2011 06:39 AM by ravindra.patil
May 27, 2011 03:24 AM|ravindra.patil|LINK
I have an report with matrix displays the data for org->doctor->month->proc name and count. as below:
Data is as below:
Matrix current result:
In bold font the data sorting is wrong. I have Row group on : org -> doctor -> Proc And
column group is on : month. Also if I removes the row group Proc it creates blank places for the procs for other months.
Can anyone have idea to sort the problem.
May 27, 2011 07:35 AM|markymark550|LINK
With your grouping, it looks like the numbers will be displayed in the order that the Proc first appears in the database for a particular doctor. And keeping the Proc in the row grouping ensures that one row will show the results for only that one Proc. For
example, Doctor1 is listed as Proc4 first followed by Proc3 and finally Proc5. That's also the order in the matrix. This explains why Doctor 3 is listed as Proc3 then Proc1 and finally Proc2 for all the months.
To fix this try the following groupings:
Row: Org -> Doctor
Column: Month -> No (descending)
Jun 08, 2011 06:34 AM|ravindra.patil|LINK
Thanks for the suggestion!
I have tried the solution but not working. In this case you removed row group proc and sorting for column group, but after doing this the result is like this.
It sorts data but creates blank rows for each procedure. I want this all three procedures in three rows only. Please help.
Jun 08, 2011 06:39 AM|ravindra.patil|LINK
I got the solutions to resolve this problem.
I have inserted a table in matrix cell. The table has only one cell and expression for the cell is set to "Proc Name" so it creates the three separate rows for the specific month. And the data is already sorted so it comes as required with three rows for each