直接sql账表，存储过账定义发布报表后前台无法显示过滤...

书写了一个存储过程：
create proc pr_hk(@f_htno varchar(30))
as
go
with table1 as
(
select FCONTACTUNIT,ltrim(rtrim(F_HTNO)) as F_HTNO,
case when MONTH(FDATE)=1 then FREALRECAMOUNT end as month_1
from T_AR_RECEIVEBILL
where FCONTACTUNITTYPE='BD_Customer' and F_HTNO<>'' and FISINIT=0
--and F_HTNO=@f_htno
),
table2 as
(
select FCONTACTUNIT,ltrim(rtrim(F_HTNO)) as F_HTNO,
case when MONTH(FDATE)=2 then FREALRECAMOUNT end as month_2
from T_AR_RECEIVEBILL
where FCONTACTUNITTYPE='BD_Customer' and F_HTNO<>'' and FISINIT=0
and F_HTNO=@f_htno
)

select * from table1 a inner join table2 b on a.FCONTACTUNIT=b.FCONTACTUNIT and a.F_HTNO=b.F_HTNO
where a.F_HTNO=@f_htno
go

然后定义了调用存储过程的sql账表