Hi frinds, first of all i want to say sorry for the my bad english...
nw i m doing live school project using c#(windows application), there
is need crystal report using student id card, i have created student id card
using crystal report,
but client asking we need single page getting two id cards for two various
students in report...
so i have posted my project's screen shot with coding,plis help me quickly,
bcoz i want summit project comming monday(2-09-2013)....
so plis help me friends... i hope u all....
plis post step by step post as coding and crystal..
and sorry for the hiding school address bcoz its my life frinds....
by murugan
this id screen shot
//////////first student id--coding
private void
idCombo1_SelectedIndexChanged(object sender, EventArgs e)
{
string
query;
try
{
sqlcon.Open();
sqlcmd = new OleDbCommand("select * from Student_Table where
Roll_No='" + idCombo1.Text + "'", sqlcon);
da = new OleDbDataAdapter(sqlcmd);
dt.Clear();
da.Fill(dt);
if (dt.Rows.Count > 0)
{
//Assign data to the primary report
ReportDocument RptDoc = new ReportDocument();
//RptDoc.Load(Application.StartupPath + @"\Report\NewTcReport.rpt");
RptDoc.Load(Application.StartupPath + "\\report\\ID_Crystal.rpt");
RptDoc.SetDataSource(dt);
//Get sub report and assign datatable1 to that report
foreach (ReportObject repOp in RptDoc.ReportDefinition.ReportObjects)
{
if (repOp.Kind == ReportObjectKind.SubreportObject)
{
string SubRepName = ((SubreportObject)repOp).SubreportName;
ReportDocument subRepDoc = RptDoc.Subreports[SubRepName];
subRepDoc.SetDataSource(dt1);
}
}
//Assign report to the crystal report viewer
crystalReportViewer1.ReportSource = RptDoc;
crystalReportViewer1.Refresh();
}
sqlcon.Close();
}
catch
(Exception ex)
{
}
}
//////////Second student id--coding
private void
idCombo2_SelectedIndexChanged(object sender, EventArgs e)
{
string
query;
try
{
sqlcon.Open();
sqlcmd = new OleDbCommand("select * from Student_Table where
Roll_No='" + idCombo2.Text + "'", sqlcon);
da = new OleDbDataAdapter(sqlcmd);
dt.Clear();
da.Fill(dt);
if (dt.Rows.Count > 0)
{
//Assign data to the primary report
ReportDocument RptDoc = new ReportDocument();
//RptDoc.Load(Application.StartupPath + @"\Report\NewTcReport.rpt");
RptDoc.Load(Application.StartupPath + "\\report\\ID_Crystal.rpt");
RptDoc.SetDataSource(dt);
//Get sub report and assign datatable1 to that report
foreach (ReportObject repOp in RptDoc.ReportDefinition.ReportObjects)
{
if (repOp.Kind == ReportObjectKind.SubreportObject)
{
string SubRepName = ((SubreportObject)repOp).SubreportName;
ReportDocument subRepDoc = RptDoc.Subreports[SubRepName];
subRepDoc.SetDataSource(dt1);
}
}
//Assign report to the crystal report viewer
crystalReportViewer1.ReportSource = RptDoc;
//crystalReportViewer1.Refresh();
}
sqlcon.Close();
}
catch
(Exception ex)
{
}
}
