阅读:2428
回复:2
|
统计报表的点击联动事件
我想点击明细表中的某一行跳转到相应的饼状图,我怎么把委托编号(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; |
1楼#
发布于:2017-11-22 10:30
可以考虑使用汇总表来代替明细表,汇总表有内置联动报表,应该可以实现亲想要的功能;
|
|
2楼#
发布于:2017-11-22 17:37
我试过了,只是参数没法作为条件去查询
SELECT ProjName,COUNT(ProjName) FROM [NDTCloud].[dbo].[I_Consign] Where ConsignNo='1' Group by ProjName; |
|