. NET Crystal Reports Use code _ Practical Tips

Required namespaces
Using CrystalDecisions.CrystalReports.Engine;
Using Crystaldecisions.web;
Using Crystaldecisions.shared;
----------------------------------------------------
Create a DataSet file
*.xsd
-----------------------------------------------------
Add a report to the page to view the control
Crystalreportviewer
--------------------------------------------------------
Background code
Dsjob dsjob = new Dsjob ();
SqlConnection scn = new SqlConnection ("server=.; uid=sa;pwd=111111;database=pubs; ");
Scn. Open ();
SqlDataAdapter SDA = new SqlDataAdapter ("Select * from Jobs", SCN);
DataSet ds = new DataSet ();
Sda. Fill (DS);
if (ds!= null && ds. Tables[0]. Rows.Count > 0)
{
foreach (DataRow Dr in DS. Tables[0]. Rows)
{
DataRow drjob = dsjob. Tables[0]. NewRow ();
drjob["job_id"] = dr["job_id"];
drjob["Job_desc"] = dr["Job_desc"];
Dsjob. Tables[0]. Rows.Add (Drjob);
}
}
Crystalreportsource Crysource = new Crystalreportsource ();
Crysource. Reportdocument.load (Server.MapPath ("cryport.rpt"));
Crysource. Reportdocument.setdatasource (Dsjob);
Crysource. DataBind ();
Cryview. ReportSource = Crysource;
Cryview. DataBind ();
Assign a value to a text control on a report
Textobject txtname = (textobject) crysource. reportdocument.reportdefinition.reportobjects["control name"];
Txtname. Text = "";