ShowReport Script Examples

This page contains script examples for the ShowReport script command.

The following example reads datatable by name "SqlTable" and project name "Test" as a report to a temporary table, and then creates a CSV file "Report1.csv" containing the datatable contents.

(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