Hi,I try to run a stored procedure using LiveReport but keep getting No Result found. But if I use Query Analyzer, I do get results. I am using MS SQL Server and I have chosen AutoLive report format. The stored procedure is:Declare
@SQL varChar(8000) DECLARE
@start Datetime,
@end DatetimeDECLARE my_cursor CursorFORSELECT distinct workaudit_workid from wworkaudit where workaudit_taskid = 23 and workaudit_status = 21CREATE TABLE #Result ( INV_NUM NVARCHAR(50), INV_DATE datetime, AMOUNT float, COMPANY NVARCHAR(255)) OPEN my_cursorDECLARE
@workflowid int,
@result int,
@avg float,
@count intSET
@result = 0SET
@count = 0FETCH NEXT from my_cursor INTO
@FETCH_STATUS <> -2) select
@start = min(workaudit_date) from wworkaudit where workaudit_taskid = 6 and workaudit_status = 29 and workaudit_workid =
@workflowid select
@end = max(workaudit_date) from wworkaudit where workaudit_taskid = 23 and workaudit_status = 21 and workaudit_workid =
@workflowid DECLARE
@PrintMessage NVARCHAR(50) SET
@SQL = 'INSERT INTO #Result SELECT AP_INVOICENUM, AP_INVOICEDATE, AP_DOLLARAMOUNT, AP_COMPANYCODE' + ' FROM iss_ap_invoice where volumeid = ' + Cast(
@workflowid as varchar(50)) EXEC (
@SQL) SET
@result =
@result + dbo.CountBizDays(
@start,
@end) SET
@count =
@count + 1 SET
@avg = cast (
@result as float) /
@count FETCH NEXT FROM MY_CURSOR INTO
@workflowid ENDCLOSE MY_CURSORDEALLOCATE MY_CURSORSELECT INV_NUM, INV_DATE, AMOUNT, COMPANY FROM #ResultDROP TABLE #ResultGO---------------------------------------------Any help will be appreciated. Thanks.
