locked
How to create a report with 3 details? RRS feed

  • Question

  • User-820736053 posted

    I have a crystal report with one detail, but when I'm trying to add another detail section , the report's details are combined. But I want the details separate from each other, like this

    detail 1 : experience

    detail 2 : education details                              what do I need to do?

    Tuesday, May 19, 2015 1:19 PM

All replies

  • User-1486182340 posted

    Hi,

    you can add multiple Details section. Right-Click on the Header of the Detail section and select "insert section below" .

    This adds a new Detail-Section after the current Detail-section:

    Details a
    Details b
    ...

    Wednesday, May 20, 2015 4:32 AM
  • User218949881 posted

    i have crytal report with multiple tables. but if i pass one parameter to SqlDataAdapter.Fill(ds,"Sale") it runs if i pass two it didn't show records on display page

    string info = ConfigurationManager.ConnectionStrings["KiranTradersContext"].ConnectionString;

    SqlConnection mycon = new SqlConnection(info);
    mycon.Open();
    string sql = "Select c.Name , p.ProductType ,s.SaleID, s.Date ,s.City, s.Mobile, s.TruckNo,s.Packets,s.Weight,s.Rate,s.Total from sale s, Product p , Customer c where s.ProductID=p.ProductID and s.CustomerID=c.CustomerID";
    SqlCommand cmd = new SqlCommand(sql, mycon);
    Reporting ds = new Reporting();

    SqlDataAdapter myda = new SqlDataAdapter(cmd);

    myda.Fill(ds, "Sale,Customer,Product");

    // if i pass here one table src it runs 
    //is there any way to dispaly two table here. i have used join query here


    ReportDocument myrpt = new ReportDocument();
    myrpt.Load(Server.MapPath("~/Reports/Saleone.rpt"));
    myrpt.SetDataSource(ds);
    CrystalReportViewer1.ReportSource = myrpt;
    CrystalReportViewer1.DataBind();

    Friday, May 29, 2015 7:56 AM