0

why crystal report displays empty fields with no data . Why dynamic binding is not happening .

here in my case

Cat_id     cat_Name is displayed no values under it is displayed

code:

 protected void Page_Load(object sender, EventArgs e)
    {
        SqlConnection con = oclsdbcon.Getconnection();
        con.Open();

        DataSet1 ds = new DataSet1();
        string str = "select Cat_Id,Cat_Name from Category_Det";

        SqlDataAdapter da = new SqlDataAdapter(str, con);

        da.Fill(ds,"DataSet1"); // DataSet1 is the DataSet1.xsd which i created and i have dragged and dropped a 
        // table category det into DataSet1 screen.

        ReportDocument rep = new ReportDocument(); // Although i have the crystalreport.rpt embedded into my website
        // still i am unable to create an object using it, so i am using this way
        rep.Load(Server.MapPath("CrystalReport.rpt"));
        rep.SetDataSource(ds ); // in the ds datasetview i have DataSet1 with values for catid and catname

        CrystalReportViewer1.ReportSource = rep ; // here i didnt know how to check the contents of rep but crystal  report viewer is not displaying any values under it .

        CrystalReportViewer1.DataBind();

    }

Edited by mike_2000_17: Fixed formatting

3
Contributors
3
Replies
4
Views
7 Years
Discussion Span
Last Post by Ezzaral
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.