sql - 报告生成器在通过钻取报告时给出错误

Question

感谢这个很棒的网站，它真的帮助我解决了所有问题。我正在使用报表生成器为 Office 版本准备仪表板。我正在使用以下查询

    declare @variable varchar
    declare @totalcount int

CREATE TABLE #MyTempEmployeeTable(version1  varchar(MAX),count1 int ,displayname0 varchar(max))
insert into #MyTempEmployeeTable(version1,count1,displayname0)
SELECT  DISTINCT (LEFT(Version0, LEN(Version0) - CHARINDEX('.', REVERSE(Version0)))), Count(DISTINCT arp.ResourceID) AS 'Count', DisplayName0
FROM fn_rbac_Add_Remove_Programs(1)  arp 
--JOIN fn_rbac_FullCollectionMembership(1)  fcm on arp.ResourceID=fcm.ResourceID 
WHERE DisplayName0 like '%Microsoft Office Professional plus%'
--and fcm.CollectionID=@CollID 
GROUP BY DisplayName0, Publisher0, Version0  


select @totalcount= sum(count1) from #MyTempEmployeeTable
--select * from #MyTempEmployeeTable
SELECT version1 as Version,sum(count1) as Modelcount,
(CAST((CAST(sum(count1) AS DECIMAL(18,2))/
     CAST((@totalcount) AS DECIMAL(18,2))) *100 as DECIMAL(18,2))) as 'Percent','%' as per,Displayname0
 from #MyTempEmployeeTable 
group by version1,displayname0
drop table #MyTempEmployeeTable

我正在查询的输出是

现在仪表板显示看起来像这样

现在问题是主要版本 15.0.4569 在通过钻取报告时出现问题，所有其他版本都工作正常，因为它们的行数较少。请找到错误快照

我无法理解它何时适用于所有其他版本，为什么这个版本不能工作，它有最大的行数。请帮忙

标签： sqlreportbuilder