protected void setReturned()
{
dsReturned dsReport = new dsReturned();
DataSet ds = execRpt.GetReport(dsReport, sSQL, sTable);
rptReturnedBooks rptViewer = new rptReturnedBooks();
pdvInstName.Value = clsVariables.sINSTITUTION;
pvCollection.Add(pdvInstName);
rptViewer.DataDefinition.ParameterFields["InsitutionName"].ApplyCurrentValues(pvCollection);
pvCollection.Clear();
pdvInstAddress.Value = clsVariables.sADDRESSS;
pvCollection.Add(pdvInstAddress);
rptViewer.DataDefinition.ParameterFields["InstitutionAddress"].ApplyCurrentValues(pvCollection);
pvCollection.Clear();
pdvInstContacts.Value = "Phone Number: " + clsVariables.sPHONENUMBER + " and " + "Fax Number: " + clsVariables.sFAXNUMBER;
pvCollection.Add(pdvInstContacts);
rptViewer.DataDefinition.ParameterFields["ContactNumber"].ApplyCurrentValues(pvCollection);
pvCollection.Clear();
pdvSchoolYear.Value = "School Year: " + sSchoolYear;
pvCollection.Add(pdvSchoolYear);
rptViewer.DataDefinition.ParameterFields["SchoolYear"].ApplyCurrentValues(pvCollection);
pvCollection.Clear();
pdvPrepared.Value = clsVariables.sLibrarianName;
pvCollection.Add(pdvPrepared);
rptViewer.DataDefinition.ParameterFields["Prepared"].ApplyCurrentValues(pvCollection);
pvCollection.Clear();
rptViewer.SetDataSource(ds);
crviewer.ReportSource = rptViewer;
}
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
rptReturnedBooks rpt = new rptReturnedBooks();
rpt.Site = this.Site;
return(rpt);
}