One of my report shows the error  "Failed to Reterive Data from database. Error in the file "Name of the Report file" (Some Key).rpt".

 

This report works perfrectly on local, I did following things to reslove the issue

a. Verify Database

b. Set DataSource Location

c. Tried copying again the file to the server

d. Exceuted the procedure and views seperately on SQL also, they are also working fine.

e. Also this is not the DSN connectivity issue, since there are other  reports also apart from this, which works perfeclty fine on application. 

 

 

But still facing the same issue. Really had a scratch with this error.

 

Usually this kind of error gets resloves if follow the above steps..But not in this case.

 

Any help in this regards would be highly appericated.

 

Thanks in Advance

Nisha