private void subConfigureCrystalReports() { string strSQL = ""; string strWhere = ""; if (dteCriter != DateTime.MinValue) strWhere = "WHERE DateDiff(\"n\", [tblTransDLBatches].[dteRetrieved], #" + dteCriter.ToString() + "#)=0 "; strSQL = "SELECT tblTransDLBatches.lngTransactionID, tblRecords.lngRecordID, " + "tblTransDLBatches.dteRetrieved, " + "tblRecords.strFirstName, tblRecords.strLastCoName, tblBlock.strBlockCode, tblTransactions.strCCNumber, tblTransactions.strCCExpDate, tblTransactions.strAuthNumber, tblTransactions.strXCAlias, tblTransactions.strXCTransID, tblTransactions.strEPSTransID, tblTransactions.strPNRef " + "FROM (((tblTransDLBatches " + "INNER JOIN tblTransactions ON tblTransDLBatches.lngTransactionID = tblTransactions.lngTransactionID) " + "INNER JOIN tblRecords ON tblTransactions.lngRecordID = tblRecords.lngRecordID) " + "LEFT JOIN tblRegistrations ON (tblTransactions.lngRegistrationID = tblRegistrations.lngRegistrationID) AND " + "(tblTransactions.lngRecordID = tblRegistrations.lngRecordID)) " + "LEFT JOIN tblBlock ON tblRegistrations.lngBlockID = tblBlock.lngBlockID " + strWhere + "ORDER BY tblTransDLBatches.dteRetrieved, tblRecords.strLastCoName, tblRecords.strFirstName"; conCTMain_B.ConnectionString = clsAppSettings.GetAppSettings().strCTConn; daTransDownloads.SelectCommand.CommandText = strSQL; daTransDownloads.Fill(dsTransDownloads, "qryTransDownloads"); tdlToPrint = new rptTransDownloads(); tdlToPrint.SetDataSource(dsTransDownloads); rvwTransDownloads.ReportSource = tdlToPrint; //determine which live charge fields to display //initially hide all live charge controls ((FieldObject)tdlToPrint.ReportDefinition.ReportObjects["txtXCTransID"]).Width = 0; ((FieldObject)tdlToPrint.ReportDefinition.ReportObjects["txtEPSTransID"]).Width = 0; ((FieldObject)tdlToPrint.ReportDefinition.ReportObjects["txtPNRef"]).Width = 0; ((FieldObject)tdlToPrint.ReportDefinition.ReportObjects["txtXCTransID"]).Height = 0; ((FieldObject)tdlToPrint.ReportDefinition.ReportObjects["txtEPSTransID"]).Height = 0; ((FieldObject)tdlToPrint.ReportDefinition.ReportObjects["txtPNRef"]).Height = 0; ((FieldObject)tdlToPrint.ReportDefinition.ReportObjects["txtXCTransID"]).Left = 0; ((FieldObject)tdlToPrint.ReportDefinition.ReportObjects["txtEPSTransID"]).Left = 0; ((FieldObject)tdlToPrint.ReportDefinition.ReportObjects["txtPNRef"]).Left = 0; ((FieldObject)tdlToPrint.ReportDefinition.ReportObjects["txtXCTransID"]).Top = 0; ((FieldObject)tdlToPrint.ReportDefinition.ReportObjects["txtEPSTransID"]).Top = 0; ((FieldObject)tdlToPrint.ReportDefinition.ReportObjects["txtPNRef"]).Top = 0; //select which cc val codes to display switch (clsLiveCharge.fcnGetLiveChargeMethod()) { //lblPNRef //txtPNRef //lblXCAuthCode //txtXCAuthCode case clsGlobalEnum.conLIVECHARGE.CashLinq: { //show pnref ((FieldObject)tdlToPrint.ReportDefinition.ReportObjects["txtPNRef"]).Width = 1590; ((FieldObject)tdlToPrint.ReportDefinition.ReportObjects["txtPNRef"]).Height = 240; ((FieldObject)tdlToPrint.ReportDefinition.ReportObjects["txtPNRef"]).Left = 9810; ((FieldObject)tdlToPrint.ReportDefinition.ReportObjects["txtPNRef"]).Top = 0; break; } case clsGlobalEnum.conLIVECHARGE.XCharge: { //show xc ((FieldObject)tdlToPrint.ReportDefinition.ReportObjects["txtXCTransID"]).Width = 1590; ((FieldObject)tdlToPrint.ReportDefinition.ReportObjects["txtXCTransID"]).Height = 240; ((FieldObject)tdlToPrint.ReportDefinition.ReportObjects["txtXCTransID"]).Left = 9810; ((FieldObject)tdlToPrint.ReportDefinition.ReportObjects["txtXCTransID"]).Top = 0; break; } case clsGlobalEnum.conLIVECHARGE.EPS: { //show eps ((FieldObject)tdlToPrint.ReportDefinition.ReportObjects["txtEPSTransID"]).Width = 1590; ((FieldObject)tdlToPrint.ReportDefinition.ReportObjects["txtEPSTransID"]).Height = 240; ((FieldObject)tdlToPrint.ReportDefinition.ReportObjects["txtEPSTransID"]).Left = 9810; ((FieldObject)tdlToPrint.ReportDefinition.ReportObjects["txtEPSTransID"]).Top = 0; break; } } }
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { rptTransDownloads rpt = new rptTransDownloads(); rpt.Site = this.Site; return rpt; }