Tuesday, January 13, 2015

3. How to get PDF directly from the Report Server (SSRS)

C#:

            var user = ConfigurationManager.AppSettings["SsrsUsername"];
            var pass = ConfigurationManager.AppSettings["SsrsPassword"];
            var domain = ConfigurationManager.AppSettings["SsrsDomain"];
            var reportUrl = ConfigurationManager.AppSettings["SsrsReportUrl"];
            var credentials = new NetworkCredential(user, pass, domain);
            var webClient = new WebClient { Credentials = credentials };
            reportUrl = string.Format(reportUrl, id);
            return this.File(webClient.DownloadData(reportUrl), "application/pdf");


WebConfig:

    <add key="SsrsUsername" value="username" />
    <add key="SsrsPassword" value="password" />
    <add key="SsrsDomain" value="DOMAIN" />
    <add key="SsrsReportUrl" value="http://192.168.1.something/ReportServer?/Folder/ReportName&amp;rs:Command=Render&amp;rs:format=PDF&amp;SomeParameter={0}"