Stimulsoft Business Intelligence System | Forum

Code: Select all

//---  configure ReportCache
StiOptions.Engine.ReportCache.LimitForStartUsingCache = 3000;
StiOptions.Engine.ReportCache.AmountOfQuickAccessPages = 3000;
StiOptions.Engine.ReportCache.CachePath = Environment.GetFolderPath(Environment.SpecialFolder.LocalApplicationData);

StiReport mainReport = new StiReport();
mainReport.Load(fileNameReportKontoauszug);
mainReport.ReportCacheMode = StiReportCacheMode.Auto;
mainReport.RenderedPages.Clear();
mainReport.NeedsCompiling = false;
mainReport.IsRendered = true;

while (recordStart < recordEnd)
{
	// fill partial datasets
	kontoauszug.Clear();
	kontoauszug.Dispose();
	kontoauszug = KontoauszugService.LoadKontoauszugByPersId(persIds);
         	
	// Render partial reports
	StiReport partialReport = new StiReport();
	partialReport.Load(fileNameReportKontoauszug);
	partialReport.DataSources.Clear();
	partialReport.RegData("Kontoauszug", kontoauszug);
	partialReport.RegData("ReportEnvironment", ReportEnvironment.GetReportEnvironment());
	partialReport.Dictionary.Synchronize();
	partialReport.ReportCacheMode = StiReportCacheMode.On;
	partialReport.RenderedPages.Clear();
	partialReport.Render();
		
	// Add rendered pages to mainreport
	mainReport.ReportCacheMode = StiReportCacheMode.On;
	foreach (StiPage reportPage in partialReport.RenderedPages)
	{
		reportPage.Report = partialReport;
		mainReport.RenderedPages.Add(reportPage);
	}		
}
mainReport.Show();

Code: Select all

recordStart < recordEnd

Code: Select all

int recordStart = 0;
int recordEnd = 20000;
int recordStep = 1000;
while (recordStart < recordEnd)
{
  string[] persIds = new string[recordStep];
  int j1 = 0;
  for (int j = recordStart; j < (recordStart + recordStep); j++)
  {
    if (!string.IsNullOrEmpty(taktgeberPersonen[j]))
      {
	persIds[j1] = taktgeberPersonen[j];
      }
      j1++;
  }
  recordStart = recordStart + j1;

  // fill partial datasets
  ...
  .. 

Code: Select all

async protected static Task<StiReport> PrepareReport(
    string a_sLogPrefix,
    string a_sTemplateFileName,
    string a_sXMLDataFileName,
    string a_sReportAlias
)
{
    string v_sLogIdent = a_sLogPrefix + "PrepareReport";

    string v_sTimes = "";

    Stopwatch v_oTMElap = new Stopwatch();
    v_oTMElap.Start();

    //Stimulsoft.Report
    StiReport v_oReport = null;// GetReport("SimpleList.mrt");
                               //StiSerializeManager x;
                               //StiExportManager xx = null

    v_oReport = new StiReport();
    
    // I tried to get, what is the path for cache file
    var a = Stimulsoft.Report.StiOptions.Engine.ReportCache.CachePath;  // Empty string for some reason
    var x = v_oReport.ReportCachePath;  // Empty string for some reason

    v_sTimes = v_sTimes + "Init: " + v_oTMElap.ElapsedMilliseconds + " ms, ";

    v_oTMElap.Restart();
    
    // report1.setReportCacheMode(StiReportCacheMode.On);
    v_oReport.ReportCacheMode = StiReportCacheMode.On;

    v_oReport.Load(a_sTemplateFileName);
    v_sTimes = v_sTimes + "Load " + v_oTMElap.ElapsedMilliseconds + " ms, ";

    // ReportAlias
    if (a_sReportAlias != "")
        v_oReport.ReportAlias = a_sReportAlias;

    v_oTMElap.Restart();
    await v_oReport.RenderAsync();  // HERE IS THE PROBLEM!!! It fails, when file with data is somewhere between 50MB and 100MB, raises an exception OutOfMemoryException.

    v_sTimes = v_sTimes + "Render " + v_oTMElap.ElapsedMilliseconds + " ms.";

    return v_oReport;
}
#endregion

async private void button1_Click(object sender, EventArgs e)
{
    var filePath = @"...\data.mrt";  // hidden in this example
    var dataFilePath = @"...\file.xml";  // hidden in this example
    var exportFilePath = @"...\report.pdf";  // hidden in this example

    StiReport v_oRep = 
        await PrepareReport(
            "x",
            filePath,
            dataPath,  // this isn't used, because we are using another way to get the data, but that's not the problem
            "test");

    var stream = new MemoryStream();

    // v_oRep.ExportDocument(StiExportFormat.Pdf, stream);
    v_oRep.ExportDocument(StiExportFormat.Pdf, stream);

    // Save to Local Storage
    using (var fileStream = File.Create(exportFilePath))
    {
        stream.Seek(0, SeekOrigin.Begin);
        stream.CopyTo(fileStream);
    }

    MessageBox.Show($"File Created: {exportFileName}");
}