ShowReport Script Examples: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 11: | Line 11: | ||
SELECT * FROM #AnalysisResult; | SELECT * FROM #AnalysisResult; | ||
(SELECT 'Title', 'Report1') UNION ALL | (SELECT 'Title', 'Report1') UNION ALL | ||
(SELECT 'MaximumCount', '0') | (SELECT 'MaximumCount', '0') | ||
--#ShowReport | --#ShowReport | ||
Revision as of 20:31, 19 September 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