新建报表提示已添加了具有相同键的项

iufida

T+-T-UFO

               
                    
【业务场景】：客户新建报表提示已添加了具有相同键的项

                               
登录/注册后可看大图

【问题解决】：备份数据，执行脚本，按会计制度不同区分脚本，再去执行脚本
2007会计制度执行脚本：-恢复2007的 增值税申报表等所有税表出厂设置，执行后重新打开就行了
DELETE  SR_ReportDataFormula where idReportDataDTO in (Select id FROM  SR_ReportData where templateID in(-1041,-1050,-1051,-1061,-1071,-1081))
DELETE  SR_ReportDataCell where idReportDataDTO in(Select id FROM  SR_ReportData where templateID in(-1041,-1050,-1051,-1061,-1071,-1081))
DELETE  SR_ReportData where templateID in(-1041,-1050,-1051,-1061,-1071,-1081)
DELETE  SR_PeriodTemplate where TemplateID in(-1041,-1050,-1051,-1061,-1071,-1081)
DELETE  SR_KeyWord  where TemplateID in(-1041,-1050,-1051,-1061,-1071,-1081)
DELETE  SR_TemplateCell where idTemplateDTO in(Select id FROM   SR_Template where templateSourceID in(-1041,-1050,-1051,-1061,-1071,-1081))
DELETE  SR_Template where templateSourceID in(-1041,-1050,-1051,-1061,-1071,-1081)
2013会计制度执行脚本：--恢复2013的 增值税申报表等所有税表出厂设置，执行后重新打开就行了
DELETE  SR_ReportDataFormula where idReportDataDTO in (Select id FROM  SR_ReportData where templateID in(-15041,-15050,-15051,-15061,-15071,-15081))
DELETE  SR_ReportDataCell where idReportDataDTO in(Select id FROM  SR_ReportData where templateID in(-15041,-15050,-15051,-15061,-15071,-15081))
DELETE  SR_ReportData where templateID in(-15041,-15050,-15051,-15061,-15071,-15081)
DELETE  SR_PeriodTemplate where TemplateID in(-15041,-15050,-15051,-15061,-15071,-15081)
DELETE  SR_KeyWord  where TemplateID in(-15041,-15050,-15051,-15061,-15071,-15081)
DELETE  SR_TemplateCell where idTemplateDTO in(Select id FROM   SR_Template where templateSourceID in(-15041,-15050,-15051,-15061,-15071,-15081))
DELETE  SR_Template where templateSourceID in(-15041,-15050,-15051,-15061,-15071,-15081)