public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
PartCollectionReport rpt = new PartCollectionReport();
rpt.Site = this.Site;
return(rpt);
}
public void ShowPartCollection(int NoofRecords,string ExchangeConn, String TicketingConn)
{
string sVersion = string.Empty;
string sSiteName = string.Empty;
try
{
LogManager.WriteLog("Inside ShowPartCollection method", LogManager.enumLogLevel.Info);
GetVersion_SiteName(out sVersion, out sSiteName);
CrystalDecisions.CrystalReports.Engine.Database crDatabase;
CrystalDecisions.CrystalReports.Engine.Tables crTables;
TableLogOnInfo tableLogonInfo = new TableLogOnInfo();
PartCollectionReport Partcol = new PartCollectionReport();
Partcol.SetParameterValue("@NumberofRecords", NoofRecords);
Partcol.SetParameterValue("SiteName", sSiteName);
Partcol.SetParameterValue("Version", sVersion);
Partcol.SetParameterValue("Region", Settings.Region);
Partcol.SetParameterValue("CurrencySymbol", ExtensionMethods.CurrentSiteCulture.GetCurrencySymbol());
IReports objReports = ReportsBusinessObject.CreateInstance(ExchangeConn, TicketingConn);
List<ServerDetails> DbConnectionInfo = objReports.GetDataBaseConnectionString(ExchangeConn);
ConnectionInfo myConnectionInfo = new ConnectionInfo();
myConnectionInfo.ServerName = DbConnectionInfo[0].ServerName; // read this information from config file.
myConnectionInfo.DatabaseName = DbConnectionInfo[0].DataBase; // 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 = Partcol.Database;
crTables = crDatabase.Tables;
foreach (CrystalDecisions.CrystalReports.Engine.Table crTable in crTables)
{
tableLogonInfo = crTable.LogOnInfo;
tableLogonInfo.ConnectionInfo = myConnectionInfo;
crTable.ApplyLogOnInfo(tableLogonInfo);
}
crystalReportViewer.ReportSource = Partcol;
AuditReports();
strReportName = "Part Collection Report";
}
catch (Exception ex)
{
throw ex;
}
}
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() {
PartCollectionReport rpt = new PartCollectionReport();
rpt.Site = this.Site;
return rpt;
}
