Hi,
I am trying to create a Crystal 8.5 report off a SQL 2000 stored procedure. When I try to make the procedure the basis of my report, it gives the error: 'No rowset was returned for this query, table or procedure.'
I have faced this before. I comment everything out and place 'SELECT 'A' AS [A] as the last line, it works. After that I usually 'un-comment' section by section and perform the 'Verify Database' step in Crystal to eventually get the original proc work with the report. This is not working for me this time.
CREATE PROCEDURE [dbo].[proc_name]
@BeginDate datetime
,@EndDate datetime
AS
CREATE TABLE #abc
(<fields> <datatype>)
INSERT INTO #abc EXECUTE [another proc] @BeginDate @EndDate
SELECT <field list>
FROM #abc INNER JOIN....<other tables>
GO
The following statement seems to be offending Crystal
INSERT INTO #abc EXECUTE [anotherproc] @BeginDate @EndDate
Any ideas on how to fix/get around this? Or perhaps something else is the issue. The procedure returns data when executed for the same parameters in SQL Query Analyzer.
Thank you for your time.
I am trying to create a Crystal 8.5 report off a SQL 2000 stored procedure. When I try to make the procedure the basis of my report, it gives the error: 'No rowset was returned for this query, table or procedure.'
I have faced this before. I comment everything out and place 'SELECT 'A' AS [A] as the last line, it works. After that I usually 'un-comment' section by section and perform the 'Verify Database' step in Crystal to eventually get the original proc work with the report. This is not working for me this time.
CREATE PROCEDURE [dbo].[proc_name]
@BeginDate datetime
,@EndDate datetime
AS
CREATE TABLE #abc
(<fields> <datatype>)
INSERT INTO #abc EXECUTE [another proc] @BeginDate @EndDate
SELECT <field list>
FROM #abc INNER JOIN....<other tables>
GO
The following statement seems to be offending Crystal
INSERT INTO #abc EXECUTE [anotherproc] @BeginDate @EndDate
Any ideas on how to fix/get around this? Or perhaps something else is the issue. The procedure returns data when executed for the same parameters in SQL Query Analyzer.
Thank you for your time.