Export a report from Telerik Report Server via .NET Client

RELATED TO:

AUTHOR: Stephania Tapela

DATE POSTED: July 07, 2017

Article information

Article relates to

Telerik Report Server

Created by

Stef, Telerik
Modified By Stef, Telerik

Last modified

July 7, 2017


FREQUENTLY ASKED QUESTION
Export a report from Telerik Report Server via .NET Client.


DESCRIPTION
Telerik Report Server has its REST API exposed allowing you to consume resources from third-party applications as an administrator, after logging in. You can find examples with JavaScript client in the REST API section of the online documentation:
  • Login and saving the access token for further usage;
  • Resources - listing resources like reports available on the Report Server;
  • Export a report by getting its ID first.
More details about the available REST API Reference.

SOLUTION 
The same JavaScript client can be written as a .NET client that executes requests and handles their response in code:
C#:
class Program
   {
       static HttpClient client = new HttpClient();
       static string reportServerAddress = "http://localhost:83/";
       static string serverREStAPI = reportServerAddress + "api/reportserver/";
       static void Main(string[] args)
       {
           Console.WriteLine("Demo started");
           RunAsync().Wait();
 
           Console.WriteLine("Demo ended");
           Console.ReadLine();
       }
 
       static async Task RunAsync()
       {
           // Our .NET Client
           client.BaseAddress = new Uri(serverREStAPI);
           client.DefaultRequestHeaders.Accept.Clear();
           client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
 
           //log the user to allow further operations
           var userToken = LogIn("admin", "admin123");
 
           //authorize further requests
           client.DefaultRequestHeaders.Authorization = new AuthenticationHeaderValue("Bearer", userToken);
 
           //list all reports
           var reports = await GetReportsAsync(serverREStAPI + "reports");
 
           //get document id for first report
           var firstReportId = reports[0]["Id"];
           var documentID = await ExportReportAsync(serverREStAPI + "documents", "PDF", firstReportId, "");
 
 
           //download PDF from documentID
           DownloadPDF(serverREStAPI + "documents/", documentID, false);
       }
 
       //log user
       static string LogIn(string usernameInput, string passwordInput)
       {
           var data = new FormUrlEncodedContent(new[]{
              new KeyValuePair<string, string>( "grant_type" ,"password" ),
               new KeyValuePair<string, string>( "username" , usernameInput ),
               new KeyValuePair<string, string>( "password" , passwordInput )
           });
           // "grant_type=password&username=" + usernameInput + "&password=" + passwordInput;
 
           HttpResponseMessage response = client.PostAsync(reportServerAddress + "Token", data).Result;
           response.EnsureSuccessStatusCode();
 
           var serializer = new System.Web.Script.Serialization.JavaScriptSerializer();
           dynamic result = serializer.DeserializeObject(response.Content.ReadAsStringAsync().Result);
           return result["access_token"];
       }
 
       //list categories
       static async Task<List<Dictionary<string, string>>> GetReportsAsync(string path)
       {
           List<Dictionary<string, string>> reports = null;
 
 
           HttpResponseMessage response = await client.GetAsync(path);
           if (response.IsSuccessStatusCode)
           {
               reports = await response.Content.ReadAsAsync<List<Dictionary<string, string>>>();
           }
           return reports;
       }
 
       //export in PDF a report
       static async Task<string> ExportReportAsync(string path, string format, string reportId, string parameterValuesJSONSerieliazed)
       {
           var data = new { ReportId = reportId, Format = format, ParameterValues = parameterValuesJSONSerieliazed };
           HttpResponseMessage response = await client.PostAsJsonAsync(path, data);
           response.EnsureSuccessStatusCode();
 
           var serializer = new System.Web.Script.Serialization.JavaScriptSerializer();
           dynamic result = serializer.DeserializeObject(response.Content.ReadAsStringAsync().Result);
           return result["DocumentId"];
       }
 
       //download PDF
       static void DownloadPDF(string path, string documentID, bool asAttachment)
       {
           var queryString = "";
 
           if (asAttachment)
           {
               queryString += "?content-disposition=attachment";
           }
 
           string fileName = "test1.pdf";
           string folderName = System.IO.Path.GetTempPath();
           string filePath = System.IO.Path.Combine(folderName, fileName);
           using (System.Net.WebClient myWebClient = new System.Net.WebClient())
           {
               myWebClient.DownloadFile(path + documentID + queryString, filePath);
           }
 
           System.Diagnostics.Process.Start(filePath);
       }
   }


Please note that this is not an end solution, but an example illustrating how to format a request to the Report Server and the type of information returned in responses. You can use any other client to submit requests and get responses by the Report Server.

More Resources

  • Forums

    Find answers to your questions or reach out to our active community

  • Feedback Portal

    Express your ideas or cast your vote for product additions and improvements.

  • Documentation

    Detailed help articles and API references for Telerik Report Server

  • Blog

    Stay up-to-date with the latest functionality, how-to articles and industry trends

  • Release History

    Telerik Report Server Release History

  • Roadmap

    Telerik Report Server Roadmap

  • FAQ

    Telerik Report Server Product FAQ

  • System Requirements

    Operating system, .NET and browser support

  • Forums

    Find answers to thousands of questions or reach out to our active community

  • Demos

    Invoices, Sales Reports, Dashboards and other reports showcasing what you can accomplish with Telerik Reporting

  • Webinars

    Sign-up for upcoming webinars and watch recorded webinars

  • User Voice

    Get answers directly from the people who build Telerik controls

  • Documentation

    Detailed help articles and API references for Telerik Reporting

  • Knowledge Base

    Tutorials and working examples on how to achieve common scenarios

  • Code Library

    Sample projects submitted by Progress staff and community members

  • Blog

    Stay up-to-date with the latest functionality, how-to articles and industry trends

  • Release History

    Complete release history for Telerik Reporting.

  • System Requirements

    Operating system, .NET and browser support