Our Training Programs

All contents are copyright of their authors.

how to retreve data using sp in crystal reprots

how to retreve data using sp in crystal reprots

Prasad Bhagat

12yAsked Nov 3, 2014, 1:36 AM1k.NET

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

Know the answer? Post it — somebody with the same question will find it here.

It is the same account you read, post and publish with — and you will come straight back to this page.

Murugesh P12y ago
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

Thanks,
Murugesh.P
Prasad Bhagat12y ago
Dear Murugeash,

Thanks for your quick reply

am done like that only but iam facing these problem

if any other suggessions plaese
Murugesh P12y ago
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.