Creating reports and dashboards | Stimulsoft community forum

Code: Select all

	private bool exportToStimulsoft(string reportFile, MemoryStream ms, DataSet data, ESA.Framework.Modelling.ModelObject host)
        {
            bool ok = false;
			string dll = null;
			//check for a precompiled version
			try
			{
				dll = reportFile.ToLower().Replace(".mrt", ".dll");
				bool recompile = !host.Session.fileExistsFS(dll);
				if (!recompile)//check file timestamps
				{
					DateTime mrtDate = host.Session.fileTimestampFS(reportFile);
					DateTime dllDate = host.Session.fileTimestampFS(dll);
					recompile = (mrtDate.CompareTo(dllDate) > 0);
				}
				if (recompile)
				{
					using (StiReport toCompile = new StiReport())
					{
						toCompile.Load(reportFile);
						toCompile.DataSources.Clear();
						toCompile.Dictionary.Databases.Clear();
						toCompile.Dictionary.ImportXMLSchema(data);
						CompilerResults r = StiReport.CompileReportsToAssembly(dll, new StiReport[] { toCompile }, StiReportLanguageType.CSharp);
						Logger.logInformation("Compiled Stimulsoft report into " + dll);
					}
				}
			}
			catch (Exception ex)
			{
				Logger.logError("Error compiling report " + reportFile, ex);
				dll = null;
			}
			if (dll != null)
			{
				try
				{
					StiReport report = StiReport.GetReportFromAssembly(dll, false);
					StiOptions.Engine.ReportCache.AllowGCCollect = true;
					report.RegData(data);
					Stimulsoft.Report.Export.StiPdfExportSettings settings = new Stimulsoft.Report.Export.StiPdfExportSettings();
					settings.Compressed = true;
					settings.EmbeddedFonts = false;
					settings.ImageQuality = host.ReportImageQuality;

                    publishStimulsoftRuntimeVariables(report);

					report.Render(false);
					report.ExportDocument(StiExportFormat.Pdf, ms, settings);
					report.Dictionary.DataStore.Clear();
					data.Clear();
					data.Dispose();
					report.Dispose();
					ms.Seek(0, SeekOrigin.Begin); //rewind stream - stimulsoft used to but does not any more
					ok = true;
				}
				catch (Exception ex)
				{
					Logger.logError("Error executing report from dll:" + reportFile, ex);
					File.Delete(dll);
				}
			}
			if(!ok)
			{
				using (StiReport report = new StiReport())
				{
					try
					{
						report.Load(reportFile);
						report.DataSources.Clear();
						report.Dictionary.Databases.Clear();
						report.Dictionary.ImportXMLSchema(data);
						report.RegData(data);
						Stimulsoft.Report.Export.StiPdfExportSettings settings = new Stimulsoft.Report.Export.StiPdfExportSettings();
						settings.Compressed = true;
						settings.EmbeddedFonts = false;
                        settings.ImageQuality = host.ReportImageQuality;

                        publishStimulsoftRuntimeVariables(report);

						report.Render(false);
						report.ExportDocument(StiExportFormat.Pdf, ms, settings);
						report.Dictionary.DataStore.Clear();
						data.Clear();
						data.Dispose();
						report.Dispose();
						ms.Seek(0, SeekOrigin.Begin); //rewind stream - stimulsoft used to but does not any more
						ok = true;
					}
					catch (FormatException fex)
					{
						host.setMessageToken(1, fex.Message);
						host.setMessageToken(2, reportFile);
						host.addSystemMessage(UserMessage.Severity.Error, reportFile + ": Format Exception:" + fex.Message, "RPT_FormatException");
						ok = false;
					}
					catch (Exception ex)
					{
						host.setMessageToken(1, ex.Message);
						host.setMessageToken(2, reportFile);
						host.addSystemMessage(UserMessage.Severity.Error, reportFile + ": There is a problem with the data sent to the report:" + ex.Message, "RPT_Exception");
						ok = false;
					}
				}
			}
            return ok;
        }