Creating reports and dashboards | Stimulsoft community forum

Code: Select all

StiVariable var1 = report.dictionary.variables.getByName("Variable1");
		var1.DialogInfo.Keys = new string[] {"1", "2", "3"};
		var1.DialogInfo.Values = new string[] {"111","222","333"};

		LongList list = new LongList();
		list.AddRange(new long[] {1,2,3});

		report.CompiledReport["Variable1"] = list;

		viewer.report = report;
		viewer.renderHtml("viewerContent");

Code: Select all

var newVariable = new Stimulsoft.Report.Dictionary.StiVariable();
newVariable.name = "Variable";
newVariable.alias = "Variable";
newVariable.type = Stimulsoft.System.StimulsoftStringList;
newVariable.requestFromUser = true;

var di = new Stimulsoft.Report.Dictionary.StiDialogInfo();
di.allowUserValues = false;
di.keys = ["1", "2", "3", "4"];
di.values = ["1", "2", "3", "4"];

newVariable.dialogInfo = di;

report.dictionary.variables.add(newVariable);
designer.onPreviewReport = function (args) {
  args.report.setVariable("Variable", ["1", "4"]);}

Code: Select all

    Uncaught ReferenceError: designer is not defined  at viewerDynamic.php:176
    designer.onPreviewReport = function (args) {

Code: Select all

		var options = new Stimulsoft.Viewer.StiViewerOptions();
		options.appearance.fullScreenMode = true;
		options.toolbar.showSendEmailButton = true;
		
		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 = "MyReportName";
		}
		
		// 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(); ?>
		}
		
		// Load and show report
		var report = new Stimulsoft.Report.StiReport();
		//report.loadFile("reports/"+"<?php echo $reportname?>"+".mrt");
		report.loadFile("reports/ReportDynamicSQLqueries.mrt");
		report.dictionary.databases.getByIndex(0).connectionString = '<?=$connStr?>';		

		
		var newVariable = new Stimulsoft.Report.Dictionary.StiVariable();
		newVariable.name = "Variable1";
		newVariable.alias = "Variable1";
		newVariable.type = Stimulsoft.System.StimulsoftStringList;
		newVariable.requestFromUser = true;

		var di = new Stimulsoft.Report.Dictionary.StiDialogInfo();
		di.allowUserValues = false;
		di.keys = ["1", "2", "3", "4"];
		di.values = ["1", "2", "3", "4"];

		newVariable.dialogInfo = di;

		report.dictionary.variables.add(newVariable);
		designer.onPreviewReport = function (args) {
		  args.report.setVariable("Variable1", ["1", "4"]);}

		viewer.report = report;
		viewer.renderHtml("viewerContent");

Code: Select all

...
report.dictionary.variables.add(newVariable);
report.setVariable("Variable", ["1", "4"]);
...
viewer.report = report;
viewer.renderHtml("viewerContent");