The Engines.ReportingServices object provides access Microsoft SQL Server Reporting Services APIs to retrieve reports in XML format.

The following example prints out the data source in the Debug Window.

 // global variables
 var g_service;
 var g_report;
 
 // configure globals and interface settings for this Klip on first run
 function onLoad() {
 	g_service = Engines.ReportingServices.createService(
					"reportingservices.dyndns.org:2020");
 
 	//g_service.secure = true;
 	//g_service.setVirtualDirectory( "ReportServer" );
 
 	// load a report based on the report's deployed project path
 	g_report = g_service.loadReport(
		"/AdventureWorks Sample Reports/Territory Sales Drilldown" );
 }
 
 function onRefresh() {
 	// run the report
 	if (g_report.run ()) {
 		var xmlsource = g_report.getXML();
 		trace( xmlsource );
 
 		// process the resulting XML
 		Engines.Data.process( g_report.getXML() );
 		return true;
 	}
 	else {
 		traceln( g_service.getLastError() );
 	}
 	return false;
 }
 

Properties Summary
boolean	secure            Specifies whether or not to use SSL/TLS for transport layer security (default is false).

Function Summary
function	createService( <String> url )            Creates a session with the server name and port combined.
function	getLastError()            Gets the latest error.
function	getXML()            Gets the XML body of the report last run.
function	loadReport( path )            Loads a report based on the report's deployed project path.
function	run()            Runs or re-runs the report that has been loaded.
function	setVirtualDirectory( reportServer )            Specifies a different report server virtual directory (default is "ReportServer").

Properties Detail

secure

boolean secure

Specifies whether or not to use SSL/TLS for transport layer security (default is false).

Set to true to use SSL/TLS.

createService

function createService( <String> url )

Creates a session with the server name and port combined.

Parameters:
url - name of the server and port (default port is 80)

getLastError

function getLastError()

Gets the latest error.

getXML

function getXML()

Gets the XML body of the report last run.

loadReport

function loadReport( path )

Loads a report based on the report's deployed project path.

Parameters:
String - path deployed project path

run

function run()

Runs or re-runs the report that has been loaded.

Returns:
true on success; otherwise false

setVirtualDirectory

function setVirtualDirectory( reportServer )

Specifies a different report server virtual directory (default is "ReportServer").

This directory is based on your IIS settings.

Parameters:
String - reportServer name of the virtual directory to set as a report server