How to create a report with 3 details?

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?

Answer 1

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
...

Answer 2

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();