fix error of query for report consolidated sales report by sub-class, subdept, report for per location sales report by class, style, sub-class,sub dept, and for the report transaction count report all braquet in department in case statement