Hello Atif,

I got where i went wrong. AS you said that ResumeLastNo was causing error.

Thanks a lot for your time and patience.

Thanks for your suggestion. But when i run it , i am still getting error.

In my SP, i have given print statements at every level to check.

Now the...

which is that nvarchar field? i didnt get 🙁

This is my PROC:

ALTER PROCEDURE [dbo].[sp_TLCOMSCandReg] (@CandID VARCHAR(50) output,@FirstName VARCHAR(100),@MiddleName Varchar(100),

@LastName VARCHAR(100),@EmailID VARCHAR(250),@MobileNo VARCHAR (15),

@PhoneNo VARCHAR (15),@DOB DATETIME,@Gender SMALLINT,@Address Varchar(250),

@Country BIGINT,@State BIGINT,@Location BIGINT,@ResumeUpload VARCHAR(100),

@TotalExperience DECIMAL(18,2),@Industry BIGINT,@FunctionalArea BIGINT,@Working SMALLINT,

@WorkingSince DATETIME,@PresentEmployer...

Hi All,

I found one more point here. the main report has 4 parameters: user location, fromdate,todate.

I am passing only @rid(user) to the subreport.

May be this is causing error. In...

Thanks! I could solve it. I had to write a condition for no data in subreport.

Now i have to go one more step deeper.

The report i am making is related...

Thanks Wayne. I am actually running the rep thru query but will soon change it to SP based on your hints.

And abt that WITH(NO LOCK), i am not sure why...

Hi Shashidhar,

Thanks for the reply. I tried it. I changed @rid to varchar in both SP and my report. but still i am getting the same error.

if i run...

Thank You very much!

Infact i was looking for this catch block code.

It really helped me.

One of the inserted values were NULL. So the statement treminated after tht.

Thanks a lot...