Skip to content

Working with report parameters

rb-cohen edited this page Dec 5, 2013 · 1 revision

An example of loading a report with given parameters.

To get parameter details

<?php
$options = array(
    'username' => 'testing',
    'password' => 'password'
);
 
$ssrs = new SSRS_Report('http://localhost/reportserver/', $options);
$result = $ssrs->loadReport('/Reports/Reference_Report');

var_dump($result->executionInfo->Parameters);

To filter a report by parameters

<?php
$options = array(
    'username' => 'testing',
    'password' => 'password'
);
 
$ssrs = new SSRS_Report('http://localhost/reportserver/', $options);
$result = $ssrs->loadReport('/Reports/Reference_Report');
 
$ssrs->setSessionId($result->executionInfo->ExecutionID);
$ssrs->setExecutionParameters(array(
    'key1' => 'value1',
    'key2' => 'value2',
));
 
$output = $ssrs->render('HTML4.0'); // PDF | XML | CSV
echo $output;