利用存储过程实现水晶报表,出现如下错误
ludf 2004-07-04 09:30:08 我写了一个存储过程,存储过程的内容如下,当我将这个存储过程从服务器资源管理器拖到Dataset1.xsd时提示错误:
发生了以下意外错误:
在将"usp_EmpMonthPrint"放到设计器时出现错误。无法对此对象解释XML构架
需要说明的是:存储过程我Exec过,没问题!请问如何解决啊?高手快帮助我!
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
-- =============================================
-- 新建存储过程
-- =============================================
ALTER PROCEDURE usp_EmpMonthPrint
@Date DateTime
AS
-- 删除输出的临时表
IF EXISTS (SELECT name FROM sysobjects WHERE name = 'dtEmpMonthPrint' AND type = 'U')
drop TABLE dtEmpMonthPrint
select HouseNo ,
Sum(case meterType when 'p1' then NumBeg else 0.0 end) DB1QS,
Sum(case meterType when 'p1' then NumEnd else 0.0 end) DB1ZS,
Sum(case meterType when 'p2' then NumBeg else 0.0 end) DB2QS,
Sum(case meterType when 'p2' then NumEnd else 0.0 end) DB2ZS,
Sum(case meterType when 'p3' then NumBeg else 0.0 end) DB3QS,
Sum(case meterType when 'p3' then NumEnd else 0.0 end) DB3ZS,
Sum(case meterType when 'w1' then NumBeg else 0.0 end) SB1QS,
Sum(case meterType when 'w1' then NumEnd else 0.0 end) SB1ZS,
Sum(case meterType when 'w2' then NumBeg else 0.0 end) SB2QS,
Sum(case meterType when 'w2' then NumEnd else 0.0 end) SB2ZS,
Sum(case meterType when 'w3' then NumBeg else 0.0 end) SB3QS,
Sum(case meterType when 'w3' then NumEnd else 0.0 end) SB3ZS,
Sum(case meterType when 'w4' then NumBeg else 0.0 end) SB4QS,
Sum(case meterType when 'w4' then NumEnd else 0.0 end) SB4ZS
into #Temp
from empWPuse
where DateData = @Date
group by houseNo
select a.empName,a.HouseNo,a.empDept,b.DB1QS,b.DB1ZS,b.DB2QS,b.DB2ZS,b.DB3QS,b.DB3ZS,c.powerprice,
a.powerFee into dtEmpMonthPrint
from empdetail a,#Temp b,empWPinfo c
where a.HouseNo = b.HouseNo and a.empArea = c.empArea and c.DateData = @Date and a.DateData = @Date
select * from dtEmpMonthPrint
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO
--exec usp_EmpMonthPrint '2004-06-01'