Error Opening File Crystal 8.5

[ddotdukes]

I continue to get the following error:

Error Opening File
There are no fields in the file [location of Stored Procedure]

The following is the code:

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO



ALTER   PROCEDURE bb_Membership_Sales

@TransactionStartDate DateTime,
@TransactionEndDate DateTime

AS

BEGIN

IF OBJECT_ID('tempdb..#Membership') IS NOT NULL DROP TABLE #Membership
CREATE TABLE #Membership
(
tixFirstName varchar(100),
tixSurName varchar(100),
tixSeriesDesc varchar(100),
tixTransactNum int,
tixCustNum int,
tixUsername varchar(100),
tixTransactDate datetime,
tixPaidPrice decimal(12,6)
 )

INSERT INTO #Membership
SELECT ssrFirstName, ssrSurname, ssrSeriesDesc, ssrTransactNum, ssrCustNum, ssrUserName, ssrTransactDate, ssrPrice 
FROM SubsStaticReport
WHERE
    ssrPrice <> 0 AND
    (ssrSeriesDesc = '9-Gold' OR
    ssrSeriesDesc = '8-Silver' OR
    ssrSeriesDesc = '7-Bronze' OR
    ssrSeriesDesc = '6-Patron' OR
    ssrSeriesDesc = '5-Supporter' OR
    ssrSeriesDesc = '4-Art Enthusiast' OR
    ssrSeriesDesc = '3-Film Lover' OR
    ssrSeriesDesc = '2-Family' OR
    ssrSeriesDesc = '1-Individual Plus') AND
    (ssrUserName <> 'PEO' AND
    ssrUserName <> 'PE Administrator') AND
    CAST(FLOOR( CAST( ssrTransactDate AS FLOAT ) )AS DATETIME) BETWEEN CAST(FLOOR( CAST( @TransactionStartDate AS FLOAT ) )AS DATETIME) and @TransactionEndDate

IF OBJECT_ID('tempdb..#Single') IS NOT NULL DROP TABLE #Single
CREATE TABLE #single
(
sinPriceType int,
)

INSERT INTO #Single
SELECT rpsPriceType
From ReportStatic
WHERE 
    rpsStatus = 1 AND
	(rpsPrice = 327 OR
	rpsPrice = 180 OR
	rpsPrice = 174 OR
	rpsPrice = 194 OR
	rpsPrice = 191 OR
	rpsPrice = 198 OR
	rpsPrice = 177 OR
	rpsPrice = 190 OR
	rpsPrice = 188 OR
	rpsPrice = 189 OR
	rpsPrice = 240 OR
	rpsPrice = 183 OR
	rpsPrice = 176 OR
	rpsPrice = 196 OR
	rpsPrice = 193 OR
	rpsPrice = 200 OR
	rpsPrice = 179 OR
	rpsPrice = 181 OR
	rpsPrice = 175 OR
	rpsPrice = 195 OR
	rpsPrice = 192 OR
	rpsPrice = 199 OR
	rpsPrice = 178 OR
	rpsPrice = 187 OR
	rpsPrice = 185 OR
	rpsPrice = 197 OR
	rpsPrice = 239 OR
	rpsPrice = 201
	rpsPrice = 186)

End

DROP TABLE #Membership
DROP TABLE #Single

 














GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

Any help would be appreciated.

 

[IanWaterman]

I think its because the SP is not returning a single data set.

Before your drop table commands, add a query relating the two tables which should yield the record set you want.

Ian

 

[ddotdukes]

Thanks Ian, I just had to add

Select * From SubsStaticReport and it worked.

You have brought back my sanity.