Crystal Report asks for Login Credentials

Question

0.00/5 (No votes)

See more:

I have prepared Crystal report.
While loading file, I passed the login information(server name, db name etc). But, when crystal report loads on the server, it asks for login information when displayed in browser.

Please suggest me?

Posted 7-Aug-10 2:27am

Kapil Kr. Khandelwal

Updated 7-Aug-10 4:12am

Sandeep Mewara

v2

Add a Solution

4 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Member 2965545 · Answer 1 · 2010-08-24T01:57:00

try this in your code behind

on page_load

add this

VB

Dim rd As ReportDocument
rd = New ReportDocument
rd.Load(Server.MapPath("Reports/CrystalReport2.rpt")) 'path to your rpt file

'sql stuff i am using a datatable
Dim dt As DataTable = DataAdaptor.GetDataTable(sql)
dt.TableName = "yourtable"

rd.SetDatabaseLogon(dbloginname;, dbpassword;)
rd.SetDataSource(dt)

Manoj Kumar Choubey · Answer 2 · 2012-06-28T04:03:00

Please see follwong links

http://forums.asp.net/t/1647609.aspx/1?Crystal+Report+Credentials+Prompt+after+deployment
http://stackoverflow.com/questions/4801835/crystal-report-credentials-prompt-after-deployment

http://crystalreporthosting.asphostcentral.com/post/Crystal-Report-Hosting-Solving-the-Login-Failed-Error-in-Crystal-Reports.aspx
http://melick-rajee.blogspot.in/2010/02/crystal-report-with-aspnet-direct.html

Shanti Lal Namchuriya · Answer 3 · 2014-12-09T20:12:00

try that open field explorer---> database field --->Right Click -->current Data source --->reports connection----->report ----->property ----> set Property as---

Data Source: .\Databasename.accdb

and code on viewer form load as

Dim cryRpt As New ReportDocument

Dim Report1 As New rptItemWise

Dim strServerName As String
strServerName = Application.StartupPath
rptItemWise.SetDatabaseLogon("admin", "", strServerName, "dastabasename.accdb", True)

cryRpt.Load(Application.StartupPath + "\rptItemWise.rpt")

also change the report connection same as data source i think that code work for you ....

arjunmca · Answer 4 · 2013-08-21T21:33:00

Hi all,
Also i have face this problem but i resolve with following way you can try it
Code:

C#

private void MYReport_Load(object sender, EventArgs e)
        {

            GenericDAL Gd = new GenericDAL();
            string error = string.Empty;
            int id = 1;
            DataSet ds = Gd.GetGetStudentData(out error, id);//My SQL stattement
            DataTable dtD = ds.Tables[0];
            CrMain Cr = new CrMain();//crystalreport name
            Cr.SetDatabaseLogon("developer", "Arjun");//Userid and password
            Cr.SetDataSource(dtD);
            crystalReportViewer1.ReportSource = Cr;
}

i think it will help.
Regards
Arjun Choubey

Crystal Report asks for Login Credentials

4 solutions

Solution 1

Solution 2

Solution 4

Solution 3

Add your solution here

Preview 0