how to retreve data using sp in crystal reprots

Question

Dear all I have a problem am developed a asp.net web application using asp.net 4.0 and sql express 2008 r2 entity freamework but now i have a problem i have procedure in db that sp retreves the latest record from db to crystal report it is simply parameterles stored procdure now iam trying to get the report using crystal report viewer but here some problem is there its showing Error Database logon failed. so please suggest me and if possible give me answer plaese

Murugesh P · Answer

Hi Prasad There are some common problems discussed in this article Just check if this helps you http://aspalliance.com/532_Understanding_the_Login_Failed_Error_in_Crystal_Reports.2 T hanks Murugesh.P

Prasad Bhagat · Answer

Dear Murugeash Thanks for your quick reply am done like that only but iam facing these problem if any other suggessions plaese

Murugesh P · Answer

Hi I am answering based on my understanding if something is wrong with my understanding kindly revert In the Menu Bar of Crystal report you have Database option -->Click Set data source Location Option-->Select your Server-->Give COrrect Password to log in-->In that Select your Sp-->Click Update Button.