ShowReport Script Examples: Difference between revisions

From QPR ProcessAnalyzer Wiki
Jump to navigation Jump to search
No edit summary
No edit summary
Line 15: Line 15:
--#ShowReport  
--#ShowReport  
</pre>
</pre>
The following script will create contents to a temporary table, and then show a pivot table from those contents.
<pre>
(SELECT 'AnalysisType', '5') UNION ALL
(SELECT 'SelectedCaseAttributes', '*') UNION ALL
(SELECT 'FilterId', CAST(@_FilterId AS NVARCHAR)) UNION ALL
(SELECT 'TargetTable', '#AnalysisResult')
--#GetAnalysis
(SELECT * FROM [#AnalysisResult])
(SELECT 'Title', 'Report1') UNION ALL
(SELECT 'SheetName', 'ShowReportResult') UNION ALL
(SELECT 'PivotSheetName', 'Pivot') UNION ALL
(SELECT 'PivotTitle', 'Pivot report name') UNION ALL
(SELECT 'PivotRows', 'Account Manager') UNION ALL
(SELECT 'PivotColumns', 'Region') UNION ALL
(SELECT 'PivotValues', 'Duration Days')
--#ShowReport
</pre>


[[Category:Examples]]
[[Category:Examples]]

Revision as of 07:06, 17 September 2020

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
Retrieved from "https://wiki.onqpr.com/pa/index.php?title=ShowReport_Script_Examples&oldid=16803"