Unusual Error with CR and SQL Server !

[vbSun]

Hi,

My colleage got an error.

"Error Opening File: There are no fields in the file LATEST.dbo.Proc(sp_CreateRptData;1)"

Its for the first time am getting this. Am using SQL Server and CR 8, anyone could show me the right direction to resolve this issue?

Anyhelp is thoroughly appreciated as things are really getting late..

Thanks,
Sunil.

------------------------------------------
The faulty interface lies between the chair and the keyboard.

 

[vidru]

Make sure that the last SELECT statement in the procedure returns data with column names, and not something like "SELECT @SomeVariable" or "SELECT @ReturnValue".

If you like, post the procedure and we'll have a look.

-dave

 

[vbSun]

Hi Dave,

Thanks for the response. I would like you to check the SQL as well. I will post it as soon as i get my hands on to it.

Thanks,
Sunil.

------------------------------------------
The faulty interface lies between the chair and the keyboard.