I have a report displaying sales by product by customer for each period in the financial year. Eg: 2010/07 2010/08 2010/09 2010/10 2010/11 2010/12 Customer1 Product 1 45 12 77 2 Product 2 2 17 18 97 Product 3 33 47 126 72 46 12 Customer2 etc My problem is this: Customer1 doesn't have any sales for its first product until 2010/10 so my list of periods gets unordered. Currently I am ordering by Customer, Period, and then Product name. If I order by Period first the customer list gets out of order etc. What's the best way to solve this?

noone?

Hi Netia, If the sorting exist some conflict, the sort will be ignored. For more information about sort please refer to these links: http://msdn.microsoft.com/en-us/library/ms157462(v=SQL.100).aspx http://msdn.microsoft.com/en-us/library/ms157313(v=SQL.100).aspx Thanks,Challen Fu [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Hi Netia, I assume you have two row groups (Customer and Product) and one column group (Date). If you set each group's sorting properties to sort by only the group field then the result will be ok (at least this is my experience with reporting services), i.e. sort the Customer group by Customer, the Product group by Product and the Date group by Date. HTH, Gerald