TechSpot

Crystal reports using c# in asp.net

By dilum
Nov 4, 2010
Post New Reply
  1. private void display(string month)
    {
    ReportDocument customerReport;
    customerReport = new ReportDocument();

    customerReport = new ReportDocument();
    string reportPath = Server.MapPath("CrystalReport.rpt");
    customerReport.Load(reportPath);

    System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(ConfigurationManager.ConnectionStrings["ConnString"].ConnectionString);
    System.Data.SqlClient.SqlDataAdapter adpt = new System.Data.SqlClient.SqlDataAdapter("SELECT number,finalcharges from invoices where invoicedate like '"+month+"%' ", conn);

    DataTable dt = new DataTable();


    adpt.Fill(dt);
    customerReport.SetDataSource(dt);
    CrystalReportViewer1.ReportSource = customerReport;
    }

    month is the index value taken from a list box




    this is the code ive used to generate crystal report in one of my asp.net web site under button click event. This create report without any errors but after that print function is not working and when try to do any modification it asks for further details by giving a window like this

    The report you requested requires further information.
    DataSet
    Server name: ...........
    Database name: .........
    User name: ..........
    Password: ...........
    (checkbox) Use Integrated Security


    please help me this is very urgent
    thank u....
     

Similar Topics

Add New Comment

You need to be a member to leave a comment. Join thousands of tech enthusiasts and participate.
TechSpot Account You may also...