关于　宏表达式的运用

各位老师好

我需要根据报表查询条件中的　两个日期(开始日期，结束日期)　，来计算去年同期的库存金额，请问我可以这样用宏表达式吗？
报表工具中，可以使用这样的ＳＱＬ查询来当数据源吗？


/*计算　去年同期　的库存金额*/
/*报表传参　查询开始日期　结束日期*/
declare @d1 date,@d2 date
set @d1 = '<#=@p9116#>'
set @d2 = '<#=@p7775#>'

/*转换　去年同期日期*/
declare @d11 date,@d22 date
set @d11 = CAST(LEFT(@d1,4)-1 AS CHAR(4)) + '-' + SUBSTRING(CONVERT(varchar(100), @d1, 23),6,2) + '-' + CAST(RIGHT(@d1,2) AS CHAR(2))
set @d22 = CAST(LEFT(@d2,4)-1 AS CHAR(4)) + '-' + SUBSTRING(CONVERT(varchar(100), @d2, 23),6,2) + '-' + CAST(RIGHT(@d2,2) AS CHAR(2))


select t00.ItmsGrpNam,t00.MaterialBrand,
t11.去年同期_初期金额,
t22.本去年同期_期入库金额,
t22.去年同期_本期出库金额,
(t11.去年同期_初期金额+t22.去年同期_本期入库金额-t22.去年同期_本期出库金额) as '去年同期_期末金额'
FROM
(
select t0.ItmsGrpNam,t0.MaterialBrand,Count(*) as '行'
FROM DEFAULT_CKJXC1017 t0
Group By t0.ItmsGrpNam,t0.MaterialBrand Having Count(*) > 1
) t00
left join
(
select t1.ItmsGrpNam, t1.MaterialBrand,(sum(t1.BQR_Amount) - sum(t1.BQC_Amount)) as '去年同期_初期金额' FROM DEFAULT_CKJXC1017 t1
where t1.DocDate < @d11
Group By t1.ItmsGrpNam, t1.MaterialBrand
) t11 on t11.ItmsGrpNam = t00.ItmsGrpNam AND t11.MaterialBrand = t00.MaterialBrand
left join
(
select t2.ItmsGrpNam, t2.MaterialBrand,
SUM(t2.BQR_Amount) AS '去年同期_本期入库金额',
SUM(t2.BQC_Amount) AS '去年同期_本期出库金额'
FROM DEFAULT_CKJXC1017 t2
WHERE t2.DocDate >= @d11 and t2.DocDate <= @d22
Group By t2.ItmsGrpNam, t2.MaterialBrand
) t22 on t22.ItmsGrpNam = t00.ItmsGrpNam AND t22.MaterialBrand = t00.MaterialBrand


在线等．．．