ShowReport Script Examples

From QPR ProcessAnalyzer Wiki
Revision as of 07:06, 17 September 2020 by Ollvihe (talk | contribs)
Jump to navigation Jump to search

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 'SheetName', 'Sheet1') UNION ALL
(SELECT 'MaximumCount', '0') 
--#ShowReport