大佬们好，目前的问题是在15的版本中，我曾设计了一个报表的模板，使用起来是正常的，现在软件更新到16后，我把模板复制过来直接使用，会报错，具体的报错信息如下：
错误明细:
GrapeCity.ActiveReports.ReportException: 一个意料之外的问题发生了。 其他信息：“SortExpressions not allowed for TablixMember without a Group.” ---> System.InvalidOperationException: SortExpressions not allowed for TablixMember without a Group.
在 GrapeCity.ActiveReports.PageReportModel.Validator.CheckForErrors(Int32 position)
在 GrapeCity.ActiveReports.PageReportModel.Validator.ValidateItem(IValidateable item)
在 GrapeCity.ActiveReports.PageReportModel.Validator.ProcessComponents(IReportComponentContainer container)
在 GrapeCity.ActiveReports.PageReportModel.Validator.ProcessComponents(IReportComponentContainer container)
在 GrapeCity.ActiveReports.PageReportModel.Validator.Validate(Report report)
在 GrapeCity.ActiveReports.Rendering.ReportProcessor.ProcessReport(Boolean skipValidation, CancellationToken cancel, ActionKey[] interactiveActions)
在 GrapeCity.ActiveReports.Rendering.ReportProcessor.Process(Boolean forceDataRefresh, Boolean forceParameterDataRefresh, CancellationToken token, Boolean skipValidation, ActionKey[] interactiveActions)
在 GrapeCity.ActiveReports.Document.PageDocument.GetRenderableReport(Boolean forceDataRefresh, Boolean forceParameterDataRefresh, CancellationToken token)
--- 内部异常堆栈跟踪的结尾 ---
在 GrapeCity.ActiveReports.Document.PageDocument.GetRenderableReport(Boolean forceDataRefresh, Boolean forceParameterDataRefresh, CancellationToken token)
在 GrapeCity.ActiveReports.Document.PageDocument.Render(IRenderingExtension renderingExtension, StreamProvider streams, NameValueCollection settings, Boolean forceDataRefresh, Boolean forceParameterDataRefresh, CancellationToken token, IProgress`1 progress)
在 GrapeCity.ActiveReports.Viewer.Common.Internal.RdlReport..<LoadImpl>b__7()
在 System.Threading.Tasks.Task.Execute()
请问我该如果处理这个问题并让表表模板可以正常查询预览？
附查询的sql语句：
select * from (
select a.DJBH, cangku.ckmc, kehu.KHMC,PSEND.RQ rq,PSEND.bz , shangpin.spdm,shangpin.SPMC,b.GGMC gg1dm,
c.GGMC gg2dm,YuanGong.YGMC,
sum(a.sl) sl,cast( round(a.ckj ,2) as real) ckj,cast(round( a.Dj ,2) as real) dj,
cast( round(sum(a.je) ,2) as real) je ,cast(round( sum(a.sl*a.ckj) ,2) as real) bzje from PSENDMX a
left join GUIGE1 b on a.GG1DM=b.GGDM
left join guige2 c on a.GG2DM=c.GGDM
inner join PSEND PSEND on a.DJBH=PSEND.DJBH
inner join KeHu kehu on PSEND.DM1=kehu.khdm
inner join CangKu on cangku.ckdm=PSEND.DM2
inner join SHANGPIN on shangpin.SPDM=a.SPDM
inner join YuanGong on PSEND.YGDM=YuanGong.YGDM
where a.DJBH=@Parameter1
group by a.DJBH, cangku.ckmc, kehu.KHMC,PSEND.rq,PSEND.bz ,
shangpin.spdm,shangpin.SPMC,b.GGMC,a.ckj,a.Dj,c.GGMC, b.GGMC,YuanGong.YGMC)
a order by gg2dm ,SPDM
|
陕公网安备：61019002000258 |
隐私政策 |
网站地图