public void ShowCashierTransactionsHistoryReport(DataSet dsReportsDataSet, DateTime StartDate, DateTime EndDate, int userNo, string UserName, string sRouteName, int Route_No, string xml) { string sVersion = string.Empty; string sSiteName = string.Empty; try { LogManager.WriteLog("Inside ShowCashierTransactionsReport method", LogManager.enumLogLevel.Info); GetVersion_SiteName(out sVersion, out sSiteName); CashierTransactionReport cashierTransactionReport = new CashierTransactionReport(); CrystalDecisions.CrystalReports.Engine.Database crDatabase; CrystalDecisions.CrystalReports.Engine.Tables crTables; TableLogOnInfo tableLogonInfo; LogManager.WriteLog("Setting Report Datasource...", LogManager.enumLogLevel.Info); cashierTransactionReport.SetDataSource(dsReportsDataSet); LogManager.WriteLog("Report DataSource set successfully", LogManager.enumLogLevel.Info); LogManager.WriteLog("Setting Report Parameters...", LogManager.enumLogLevel.Info); cashierTransactionReport.SetParameterValue("SiteCode", Settings.SiteCode); cashierTransactionReport.SetParameterValue("@startdate", StartDate); cashierTransactionReport.SetParameterValue("@enddate", EndDate); cashierTransactionReport.SetParameterValue("@User", userNo); cashierTransactionReport.SetParameterValue("@Route_No", Route_No); //cashierTransactionReport.SetParameterValue("DateCulture", ExtensionMethods.CurrentDateCulture); cashierTransactionReport.SetParameterValue("Version", sVersion); cashierTransactionReport.SetParameterValue("SiteName", sSiteName); cashierTransactionReport.SetParameterValue("UserName", UserName); cashierTransactionReport.SetParameterValue("RouteName", sRouteName); //cashierTransactionReport.SetParameterValue("CurrencyCulture", ExtensionMethods.CurrentCurrenyCulture); cashierTransactionReport.SetParameterValue("CurrencySymbol", ExtensionMethods.CurrentCurrenyCulture.GetCurrencySymbol()); cashierTransactionReport.SetParameterValue("@xml", xml); IReports objReports = ReportsBusinessObject.CreateInstance(); List<ServerDetails> DbConnectionInfo = objReports.GetDataBaseConnectionString(); ConnectionInfo myConnectionInfo = new ConnectionInfo(); myConnectionInfo.ServerName = DbConnectionInfo[0].ServerName; // read this information from config file. myConnectionInfo.DatabaseName = "Ticketing"; // read this information from config file. myConnectionInfo.UserID = DbConnectionInfo[0].Username; // read this information from config file. myConnectionInfo.Password = DbConnectionInfo[0].Password; // read this information from config file. crDatabase = cashierTransactionReport.Database; crTables = crDatabase.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table crTable in crTables) { tableLogonInfo = crTable.LogOnInfo; tableLogonInfo.ConnectionInfo = myConnectionInfo; crTable.ApplyLogOnInfo(tableLogonInfo); } LogManager.WriteLog("Report Parameters set successfully", LogManager.enumLogLevel.Info); LogManager.WriteLog("Setting Report Source...", LogManager.enumLogLevel.Info); crystalReportViewer.ReportSource = cashierTransactionReport; LogManager.WriteLog("Report Source set successfully", LogManager.enumLogLevel.Info); AuditReports(); strReportName = "Cashier Transaction History Summary"; } catch (Exception ex) { throw ex; } }