Ordering of matrix with limited data
Hi, I have a report with a matrix that displays customers per rows and months along the columns. The details shows sales volume. I want the report to order by customer name regardless of what data is available, but am having a problem. The report runs in customer order for those customers where all months have data, however for customer with sales volume from February (for example) onwards they appear underneath the other customers, out of alphabetical order. To help explain this, the report comes out as follows (hopefully it formats OK!). I would like C customer to appear between B and D, but it doesn't because we have no sales data for Jan for that customer. I could edit the query to pull back zeroes where there are no sales, but was hoping for a slightly easier solution than that within SSRS. Jan Feb Mar April A customer 5 5 6 7 B Customer 8 9 5 6 D Customer 2 9 8 5 C Customer 3 7 9 Thanks in advance, T
February 22nd, 2011 10:57am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics