SSRS export to excel/Pdf in console application in C#

SSRS (SQL Server Reporting Services) export to excel in console application in C#

Namespace:

using RestSharp;
using RestSharp.Authenticators;
using System;

using System.IO;

   private static void GenerateReport(string strReportPath,string _parameters, string FileName, string FileType = "Excel")

        {

            try

            {

                string strReportPath = strReportPath;//"UserDetails"

                //string FileType = "Excel";

                string URL = ConfigurationManager.AppSettings["ReportServerPath"].ToString() + "?" + strReportPath + "&rs:Command=Render&rs:Format=" + FileType + _parameters;

 

                var client = new RestClient(URL);                

                client.Authenticator = new NtlmAuthenticator(ConfigurationManager.AppSettings["ReportUser"].ToString(), ConfigurationManager.AppSettings["ReportPwd"].ToString());

                var request = new RestRequest(Method.GET);

                Byte[] FileByte = client.DownloadData(request);

 

                ByteToFile(FileName, FileByte, FileType);

            }

            catch (Exception ex)

            {

                throw;

            }

        }

        static void ByteToFile(string FileName, Byte[] bytes, string FileType)

        {

            string path = AppDomain.CurrentDomain.BaseDirectory + "\\Data";

            if (!Directory.Exists(path))

            {

                Directory.CreateDirectory(path);

            }

            path = AppDomain.CurrentDomain.BaseDirectory + "\\Data\\" + System.DateTime.Now.ToString("yyyyMMdd");

            if (!Directory.Exists(path))

            {

                Directory.CreateDirectory(path);

            }

            if (FileType == "Excel")

            {

                FileName += ".xls";

            }

            else

            {

                FileName += ".pdf";

            }

            File.WriteAllBytes(path + "\\"+ FileName, bytes);

        }

Excel Export Example:

GenerateReport("UserDetails", "&From=11-Aug-2020&UpTo=01-Jan-2021", "UserDetails","Excel');

PDF Export Example:

GenerateReport("UserDetails", "&From=11-Aug-2020&UpTo=01-Jan-2021", "UserDetails","Pdf');