private void button1_Click(object sender, EventArgs e)
{
var report = new rptTestimonial();
ParameterValues pvValues = new ParameterValues();
ParameterDiscreteValue pdvDiscreteValue = new ParameterDiscreteValue();
pdvDiscreteValue.Value = textBox1.Text;
pvValues.Add(pdvDiscreteValue);
ParameterFieldDefinitions pfdDefinitions = report.DataDefinition.ParameterFields;
ParameterFieldDefinition prdDefinition = pfdDefinitions["textThing"];
prdDefinition.ApplyCurrentValues(pvValues);
/*var data =
Database.Row("learner_details a, enrollments b, enrollmentscourses c, courses d",
"a.Division = '" + clsGlobal.loggedOnUserDivison + "' AND a.LearnerNumber = '" +
number.Selection +
"' AND b.LearnerKey = a.LearnerKey AND c.idEnrollments = b.idEnrollments AND" +
" d.idCourses = c.idCourses");*/
report.DataDefinition.FormulaFields["mainText"].Text = "\"" + textBox1.Text + "\"";
report.DataDefinition.FormulaFields["principle"].Text = "\"" + GlobalProperties.DivisionPrinciple + "\"";
report.DataDefinition.FormulaFields["name"].Text = "\"" + learner["Surname"] + ", " + learner["name"]+ "\"";
report.DataDefinition.FormulaFields["learnerNumber"].Text = "\"" + number + "\"";
//report.DataDefinition.FormulaFields["respParty"].Text = "\"" + clsGlobal.loggedOnUser + "\"";
//report.DataDefinition.FormulaFields["course"].Text = "\"" + Convert.ToString(data["Name1"]) + "\"";
//logs.WriteXml(@"C:\tmpXml.xml");
var frmReport = new frmReport(report) { Text = "Testimonial" };
frmReport.ShowDialog();
}
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
rptTestimonial rpt = new rptTestimonial();
rpt.Site = this.Site;
return rpt;
}