Logon Failed in crystal report 13

Question

0.00/5 (No votes)

See more:

Hi,

Here i am developing one desktop application by using c#. In that project am using crystalreport with ms access as database. But at the time of running when i am opening report it is asking user name and password, I havnt given any password for database,dynamically i have set servername and database, but it not working. The same code is working in another report and its opening very well. Here is my code

OleDbCommand cmdGet = new OleDbCommand("SELECT * FROM supp_due where suppid= '" + TextBox2.Text.Trim() + "'", MyCon.Con);
          
            OleDbDataAdapter adGet = new OleDbDataAdapter(cmdGet);
            DataSet dsGet = new DataSet();
            adGet.Fill(dsGet, "supp_due");
 SupplierRpt2 _SupRpt = new SupplierRpt2();
            _SupRpt.DataSourceConnections[0].SetConnection(Application.StartupPath.ToString(), "Shop.mdb","","");
            _SupRpt.SetDataSource(dsGet);
            
            CrystalReportViewer1.ReportSource = _SupRpt;
            
            CrystalReportViewer1.Refresh();

So please help me

Thanks
Sujith

Posted 19-Jan-12 19:01pm

sujithmtla

Updated 19-Jan-12 23:05pm

Jαved

v2

Add a Solution

Comments

Jαved 20-Jan-12 5:06am

Added pre tag.

1 solution

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)

Prashant Srivastava LKO · Answer 1 · 2012-01-19T19:36:00

Try Below code only change the class and method inside

C#

DataTable dt = new DataTable();
         dt = Module.fillgridProject();
            try
            {
                if (dt.Rows.Count > 0)
                {
                    ReportDocument rptdoc = new ReportDocument();
                    rptdoc.Load(Server.MapPath("~\\Reports\\ModuleReport.rpt"));
                    rptdoc.SetDataSource(dt);
                    //crv.ReportSource = rptdoc;
                    //crv.DataBind();
                    ExportOptions exportOpts1 = rptdoc.ExportOptions;
                    rptdoc.ExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat;
                    rptdoc.ExportOptions.ExportDestinationType = ExportDestinationType.DiskFile;
                    rptdoc.ExportOptions.DestinationOptions = new DiskFileDestinationOptions();
                    ((DiskFileDestinationOptions)rptdoc.ExportOptions.DestinationOptions).DiskFileName = Server.MapPath("ProjectReport.pdf");
                    rptdoc.Export();
                    rptdoc.Close();
                    rptdoc.Dispose();
                    Response.ClearContent();
                    Response.ClearHeaders();
                    Response.ContentType = "application/pdf";
                    Response.AppendHeader("Content-Disposition", "attachment; filename=ProjectReport.pdf");
                    Response.WriteFile("ProjectReport.pdf");
                    Response.Flush();
                    Response.Close();
                   System.IO.File.Delete(Server.MapPath("ProjectReport.pdf"));
                }
                else
                {
                    Messagebox1.Show("No Record for this Project");
                }
            }
            catch 
            {
                Page.ClientScript.RegisterStartupScript(this.GetType(), "Hello", "javascript:alert('No Data Present');", true);
            }