统计报表的点击联动事件

我想点击明细表中的某一行跳转到相应的饼状图，我怎么把委托编号（ConsignNo）当做参数传递过去
下面是对应的明细表和饼状图的sql语句


SELECT ConsignNo as '委托编号', COUNT(ConsignNo) as '数目' from [NDTCloud].[dbo].[I_Consign]Group by ConsignNo;

SELECT ProjName,COUNT(ProjName)
FROM [NDTCloud].[dbo].[I_Consign]Where ConsignNo='1'
Group by ProjName;

可以考虑使用汇总表来代替明细表，汇总表有内置联动报表，应该可以实现亲想要的功能；

我试过了，只是参数没法作为条件去查询
SELECT ProjName,COUNT(ProjName)
FROM [NDTCloud].[dbo].[I_Consign]
Where ConsignNo='1'
Group by ProjName;