Failed to open Rowset?

[nmmure]

Hi,

I am trying to preview the report it is showing following error
" Failed to open rowset.
Details: 42000:[Microsoft][ODBC SQL Server Driver][SQL Server]NM08 check your options: you must enter a customer code to run this report "

this report is having 3 paramertes I supply the correct param values, this report is looking for another value customer code , this customer code is not parameter, pls guide me how can i select or supply the customer code?

this report is running by stored procedure, Database "SQL Server 2000" and "Crystal report 10"

 

[Madawc]

I had a similar problem, and never fully solved it, just worked round it by trial-and-error.

Have you changed something and was customer code formerly a parameter? Stored Procedures in Crystal 10 are very fussy and it might be better to begin again with a fresh Crystal.

Temporary files can also be a problem, if you're using them. I got best results using

If Object_ID('Tempdb.dbo.#File_AA') Is Not Null
	DROP 	TABLE	#File_AA

And so on for all files used in SQL. Sometimes also it worked after I edited the SQL to change the name of the temporary files.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10