Reporting Service 小计和总计问题
我有一张表数据有unit_Id,Region_Id,Floor_Id,Category_Id,和一些记录数值的字段,我在Reporting中拖入了小计和总计,
小计和总计效果出来了,但是小计的效果不是我要的,我需要小计按照Region_Id排序,难道我Reportingservice中还要设置么?
我代码是
SELECT BaseInfo_PX_Connection.Shop_Id, BaseInfo_PX_Region.Region_Name,
BaseInfo_PX_Shop.Shop_Name, BaseInfo_PX_Unit.Unit_Name,
BaseInfo_PX_Floor.Floor_Name, BaseInfo_PX_Category.Category_Name,
BaseInfo_PX_YearWorkMode.Area_TotalThis,
BaseInfo_PX_YearWorkMode.Area_TotalLast, BaseInfo_PX_Region.Region_Id,
BaseInfo_PX_Unit.Unit_Id,
SUM(BaseInfo_PX_YearWorkMode.Arrent_ThisYear + BaseInfo_PX_YearWorkMode.Other_Csml_ThisYear
+ BaseInfo_PX_YearWorkMode.Three_Csml_ThisYear) AS 'ArentCsmlThisyear',
SUM(BaseInfo_PX_YearWorkMode.Arrent_LastYear + BaseInfo_PX_YearWorkMode.Other_Csml_LastYear
+ BaseInfo_PX_YearWorkMode.Three_Csml_LastYear)
AS 'ArentCsmlLastYear'
FROM BaseInfo_PX_Category INNER JOIN
BaseInfo_PX_Connection ON
BaseInfo_PX_Category.Category_Id = BaseInfo_PX_Connection.Category_Id INNER JOIN
BaseInfo_PX_Floor ON
BaseInfo_PX_Connection.Floor_Id = BaseInfo_PX_Floor.Floor_Id INNER JOIN
BaseInfo_PX_Region ON
BaseInfo_PX_Connection.Region_Id = BaseInfo_PX_Region.Region_Id INNER JOIN
BaseInfo_PX_Shop ON
BaseInfo_PX_Connection.Shop_Id = BaseInfo_PX_Shop.Shop_Id INNER JOIN
BaseInfo_PX_Unit ON
BaseInfo_PX_Connection.Unit_Id = BaseInfo_PX_Unit.Unit_Id INNER JOIN
BaseInfo_PX_YearWorkMode ON
BaseInfo_PX_Connection.Connection_Id = BaseInfo_PX_YearWorkMode.Connection_Id
WHERE (BaseInfo_PX_YearWorkMode.Unit_Id = @Unit_Id) AND
(BaseInfo_PX_YearWorkMode.Time = @Time)
GROUP BY BaseInfo_PX_Connection.Shop_Id, BaseInfo_PX_Shop.Shop_Name,
BaseInfo_PX_Floor.Floor_Name, BaseInfo_PX_Category.Category_Name,
BaseInfo_PX_YearWorkMode.Area_TotalLast,
BaseInfo_PX_YearWorkMode.Area_TotalThis, BaseInfo_PX_Region.Region_Id, BaseInfo_PX_Region.Region_Name,
BaseInfo_PX_Unit.Unit_Id,BaseInfo_PX_Unit.Unit_Name
ORDER BY BaseInfo_PX_Connection.Shop_Id
菜鸟飘过