ShowReport Script Examples: Difference between revisions

From QPR ProcessAnalyzer Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
Line 1: Line 1:
This page contains script examples for the [[QPR ProcessAnalyzer Scripting Commands#--.23ShowReport|ShowReport]] script command.
This page contains script examples for the [[SQL Scripting Commands#--.23ShowReport|ShowReport]] script command.


The following example opens the data table identified by data table name "SqlTable" and project name "Test" as a report.
The following example opens the data table identified by data table name "SqlTable" and project name "Test" as a report.

Revision as of 20:49, 25 October 2021

This page contains script examples for the ShowReport script command.

The following example opens the data table identified by data table name "SqlTable" and project name "Test" as a report.

(SELECT 'AnalysisType', '18') UNION ALL
(SELECT 'ProjectName', 'Test') UNION ALL
(SELECT 'DataTableName', 'SqlTable') UNION ALL
(SELECT 'TargetTable', '#AnalysisResult')
--#GetAnalysis

SELECT * FROM #AnalysisResult; 
(SELECT 'Title', 'Report1') UNION ALL
(SELECT 'MaximumCount', '0') 
--#ShowReport