'q' + datename(qq, salesorderheader.orderdate) as orderqtr, //季度sum(salesorderdetail.unitprice * salesorderdetail.orderqty) as sales//销售数据
from productsubcategory inner join
………………….
where (salesorderheader.orderdate between '1/1/2002' and '12/31/2003')//时间范围
//这里的group by保证数据的层次关系
group by
datepart(yy, salesorderheader.orderdate), productcategory.name, productsubcategory.name, 'q' + datename(qq,
salesorderheader.orderdate), productsubcategory.productsubcategoryid</commandtext>
下面再来看看rdl中是如何指定季度列隐藏在年份下面的
<columngrouping>
<dynamiccolumns>
