Pass DataSource Credentials?

I need to keep my SSRS datasource as "prompt for credentials" since we are also using another solution that requires that, but I'm unsure how to set the DataSourceCredentials in my solution. I get the error: System.Web.Services.Protocols.SoapException: One or more data source credentials required to run the report have not been specified.

Here's my code:

        $options = [
            'username' => $this->getParameter('ssrs_user'),
            'password' => $this->getParameter('ssrs_password')
        ];

        $ssrs = new SSRS\Report($this->getParameter('ssrs_server'), $options);
        $result = $ssrs->loadReport($this->getParameter('ssrs_base').'/'.$request->get('report'));

        $ssrs->setSessionId($result->executionInfo->ExecutionID);
        $parameters = json_decode($request->get('parameters'),true);
        $ssrs->setExecutionParameters(new SSRS\Object\ExecutionParameters($parameters));

        $output = $ssrs->render('HTML4.0'); // PDF | XML | CSV | HTML4.0 | Excel
        return $output;

What else do I need to add?

Found a solution. Had to create my own method in Report.php to set execution credentials:

public function setDataSourceCredentials($datasource,$username,$password) {
        $this->checkSessionId();

        $options = array(
            'Credentials' => array(
                'DataSourceCredentials' => array(
                    'DataSourceName' => $datasource,
                    'UserName' => $username,
                    'Password' => $password
                )
            )
        );

        $result = $this->getSoapExecution()->SetExecutionCredentials($options);
        return new ExecutionInfo($result);
    }

Navigation Menu

Repository navigation

Pass DataSource Credentials? #32

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

Pass DataSource Credentials? #32

Description

Activity

kenvalleydc commented on Jul 21, 2018

Metadata

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

Issue actions