Creating reports and dashboards | Stimulsoft community forum

Code: Select all

		
{...}
		Stimulsoft.Base.Localization.StiLocalization.setLocalizationFile("localization/de.xml", true);
		var options = new Stimulsoft.Viewer.StiViewerOptions();
		options.appearance.fullScreenMode = true;
		options.toolbar.showSendEmailButton = true;
		options.toolbar.showPrintButton = false;
		
		var viewer = new Stimulsoft.Viewer.StiViewer(options, "StiViewer", false);
		
		// Process SQL data source
		viewer.onBeginProcessData = function (event, callback) {
			<?php StiHelper::createHandler(); ?>
		}
		
		// Manage export settings on the server side
		viewer.onBeginExportReport = function (args) {
			<?php StiHelper::createHandler(); ?>
			args.fileName = "<?php echo $_GET['id'] ?>_Auftrag";
		}
		
		// Process exported report file on the server side
		viewer.onEndExportReport = function (event) {
			event.preventDefault = true; // Prevent client default event handler (save the exported report as a file)
			<?php StiHelper::createHandler(); ?>
		}
		
		// Send exported report to Email
		viewer.onEmailReport = function (event) {
			<?php StiHelper::createHandler(); ?>
		}
		
		viewer.onPrintReport = function (event) {
			<?php StiHelper::createHandler(); ?>
		}
		
	// Load Data
	var report = new Stimulsoft.Report.StiReport();		
	var dataSet = new Stimulsoft.System.Data.DataSet('Auftrag');	
	
	var recievedData = '';	
	
	$.ajax({
		async: false,
		type: 'GET',
		url: "../../../get_Auftrag.php",
		data: { id: '<?php echo $_GET['id']; ?>'},
		success: function(data){
			recievedData = data;
		}
	});		

		// Load and show report

		//dataSet.readJson(recievedData);
		var jsonData = Stimulsoft.Base.StiJsonToDataSetConverter.getDataSet(recievedData);

		report.regData(Auftrag', 'Auftrag', jsonData);
		
		// Load report
		//alert(recievedData.vorgang.art);
		
		report.loadFile("reports/"+recievedData.Head.Report);
	
		report.dictionary.synchronize();	
		
		viewer.report = report;
		
		viewer.renderHtml("viewerContent");
{...}

Code: Select all

console.log('start report rendering @ '+ new Date().toLocaleString() );
{...}
		var dataPromise = getData('../../../get_Auftrag.php?id='+query.id);

		dataPromise.then(JSON.parse, errHandler)
			.then(function(result){				
				Stimulsoft.Base.StiFontCollection.addOpentypeFontFile("./Roboto-Black.ttf");
				
				var report = new Stimulsoft.Report.StiReport();

				Stimulsoft.Base.Localization.StiLocalization.setLocalizationFile("../../../localization/de.xml");
				// Loading report template
				report.loadFile("../../../reports/VorgangRechnung.mrt");		
				console.log("Report template loaded");

				// Create new DataSet object
				var dataSet = new Stimulsoft.System.Data.DataSet("Auftrag");
				console.log("create dataset");
				
				// Load JSON data file from specified URL to the DataSet object
				dataSet.readJson(result);
				console.log("read JSON to dataset");
				
				// Remove all connections from the report template
				//report.dictionary.databases.clear();
				//console.log("clear dictionary");
				
				// Register DataSet object
				report.regData("Auftrag", "Auftrag", dataSet);
				console.log("register dataset into dictionary");
				
				// Sync Dictionary
				report.dictionary.synchronize();
				console.log("synchronize dictionary");
				
				// Renreding report
				report.render();
				console.log("Report rendered. Pages count: ", report.renderedPages.count);

				// Export to PDF
				var pdfData = report.exportDocument(Stimulsoft.Report.StiExportFormat.Pdf);
				console.log('export rendered report');
							
				// Converting Array into buffer
				var buffer = new Buffer(pdfData, "utf-8")
				console.log("write rendered report to buffer");

				// Saving string with rendered report in PDF into a file
				fs.writeFileSync('./'+result.Auftrag.RechnungenID+'_Rechnung.pdf', buffer);
				console.log("Rendered report saved into PDF-file.");	
				console.log(result.Auftrag.RechnungenID+'_Rechnung.pdf');
			}, errHandler);
{...}							

Code: Select all

Stimulsoft.Reports.JS
Version: 2018.3.4
Build date: 2018.11.08

Code: Select all

Stimulsoft.Reports.JS
Version: 2018.1.6
Build date: 2018.01.20