Scheduling SSRS Reports from asp.net application:

Scheduling SSRS Reports from asp.net application:

Creating the Web Service Proxy:

To add a proxy class to your project using Wsdl.exe

From a command prompt, use Wsdl.exe to create a proxy class, specifying (at a minimum) the URL to the Report Server Web service. For example, the following command prompt statement specifies a URL for the management endpoint of the Report Server Web service:

Copy :  wsdl /language:CS /n:"Microsoft.SqlServer.ReportingServices2010" http:///reportserver/reportexecution2005.asmx?wsdl

Add Proxy Class to your Project: add this class file to your project which common project in the project. Access this class from data Access layer.

Button clicks Event to save Schedule:

  try
            {
                    ReportSchedule reportschedule = new ReportSchedule();
                    ReportServerCredentials credentials = new ReportServerCredentials();

                    reportschedule.Credentials = credentials.NetworkCredentials;
                    //System.Net.CredentialCache.DefaultCredentials;
                    string eventType = "TimedSubscription";
                    string matchData = GetMatchData();
                    ExtensionSettings extSettings = GetExtensionSettings();
                    // Set the report parameter values.
                    ParameterValue[] parameters = SetReportSubScriptionParameters(strReportParams);
                    string subscriptionID = reportschedule.CreateSubscription(strReportName, extSettings, strReportDesc, eventType, matchData, parameters);
                    bool createdSubscription = objReportSchedule.CreateReportSubScription(subscriptionID, UserId, strReportName, txtReportName.Value);
                    if (createdSubscription)
                    {
                        string strReport = string.Format("{0} has been scheduleed successfully ", Convert.ToString(Request.QueryString["ReportName"]));
                        ApplicationLog.WriteInfo(strReport,"HSW_ReportViewer.btnSaveSchedule_Click", UserId);
                        Response.Write("");
                        rdbtnDailyOptions.Checked = true;
                    }
            }

            catch (SoapException ex)
            {
                ApplicationLog.WriteError(ex.Message,"HSW_ReportViewer.btnSaveSchedule_Click");
            }

User defined Methods to Proceed:

GetMatchData: which we are passing to Reporting Server in Extension Settings .This function will get the start Date/End Date, Daily pattern, weekly pattern, Monthly pattern usingSchedule Definition Class. Schedule Definition will api from Web services Proxy Class.Schedule Definition have variable like StartDateTime, EndDateSpecified, EndDate,Item(Pattern either daily/Weekly/Monthly).

   private string GetMatchData()
        {
            ScheduleDefinition schedule = new ScheduleDefinition();
            schedule.StartDateTime = Convert.ToDateTime(txtStartDate.Value, newCultureInfo("en-US"));
            schedule.EndDateSpecified = true;
            schedule.EndDate = Convert.ToDateTime(txtEndDate.Value, new CultureInfo("en-US"));
            if (rdbtnDailyOptions.Checked)
                schedule.Item = GetDailyPattern();
            else if (rdbtnWeekly.Checked)
                schedule.Item = GetWeeklyPattern();
            else if (rdbtnMonthly.Checked)
            {
                if (rdbtnWeekOfMonthly.Checked)
                    schedule.Item = GetMonthlyDOWRecurrence();
                else
                {
                    schedule.Item = GetMonthlyPattern();
                }
            }

            XmlDocument xmlDoc = GetScheduleAsXml(schedule);
            return xmlDoc.OuterXml;

        }
GetDailyPattern: which return DailyRecurrence. It has Days Interval
        /// Get Daily Pattern
        /// 

        /// 
        private DailyRecurrence GetDailyPattern()
        {

            DailyRecurrence pattern = new DailyRecurrence();
            //if (rdbtnDaily1.Checked)
            pattern.DaysInterval = Convert.ToInt32(txtDay.Value);

            return pattern;
        }
GetWeeklyPattern: which return WeeklyRecurrence. It has Days Of Week, Weeks Interval,WeekIntervalSpeficied

        ///         /// Get Weekly Pattern
        /// 
        /// 
        private WeeklyRecurrence GetWeeklyPattern()
        {
            WeeklyRecurrence pattern = new WeeklyRecurrence();
            DaysOfWeekSelector days = new DaysOfWeekSelector();
            pattern.DaysOfWeek = GetDays(days, rdbtnWeeklist);
            pattern.WeeksIntervalSpecified = true;
            pattern.WeeksInterval = Convert.ToInt32(txtRepeatWeek.Value);
            return pattern;
        }
GetMonthlyPattern: which returns MonthlyRecurrence ,It has Calendar Days as days,month of Year


        /// GetMonthly Pattern
        /// 
        /// 
        private MonthlyRecurrence GetMonthlyPattern()
        {

            MonthlyRecurrence pattern = new MonthlyRecurrence();
            pattern.Days = txtCalendarmonthly.Value;
            pattern.MonthsOfYear = SetMonths();
            return pattern;
        }
GetMonthlyDOWRecurrence:which returns MonthlyDOWRecurrence,It has WhichWeekSpecified, DaysOfWeek, MonthsOfYear, WhichWeek
        /// 
        /// GetMonthlyDOWRecurrence
        /// 
        /// 
        private MonthlyDOWRecurrence GetMonthlyDOWRecurrence()
        {
            MonthlyDOWRecurrence pattern = new MonthlyDOWRecurrence();
            pattern.WhichWeekSpecified = true;
            DaysOfWeekSelector days = new DaysOfWeekSelector();
            pattern.DaysOfWeek = GetDays(days, rdbtnMonthlyWeeks);
            pattern.MonthsOfYear = SetMonths();
            switch (Convert.ToInt32(ddlWeeks.Value))
            {
                case 1:
                    pattern.WhichWeek = WeekNumberEnum.FirstWeek; break;
                case 2:
                    pattern.WhichWeek = WeekNumberEnum.SecondWeek; break;
                case 3:
                    pattern.WhichWeek = WeekNumberEnum.ThirdWeek; break;
                case 4:
                    pattern.WhichWeek = WeekNumberEnum.FourthWeek; break;
                case 5:
                    pattern.WhichWeek = WeekNumberEnum.LastWeek; break;
            }
            return pattern;
        }
GetDays: which returns DaysOfWeekSelector.It has Week Selector.
        /// 

        /// Get Days
        /// 
        /// 
        /// 
        /// 
        private DaysOfWeekSelector GetDays(DaysOfWeekSelector days, RadioButtonListrdbtnWeeklist)
        {
            switch (Convert.ToInt32(rdbtnWeeklist.SelectedValue))
            {
                case 0:
                    days.Sunday = true;
                    break;
                case 1:
                    days.Monday = true;
                    break;
                case 2:
                    days.Tuesday = true;
                    break;
                case 3:
                    days.Wednesday = true;
                    break;
                case 4:
                    days.Thursday = true;
                    break;
                case 5:
                    days.Friday = true;
                    break;
                case 6:
                    days.Saturday = true;
                    break;

            }
            return days;
        }
         /// 

        /// set Months
        /// 
        /// 
        private MonthsOfYearSelector SetMonths()
        {
            MonthsOfYearSelector monthselector = new MonthsOfYearSelector();
            monthselector.January = true;
            monthselector.February = true;
            monthselector.March = true;
            monthselector.April = true;
            monthselector.June = true;
            monthselector.July = true;
            monthselector.August = true;
            monthselector.September = true;
            monthselector.October = true;
            monthselector.November = true;
            monthselector.December = true;
            return monthselector;
        }
    }
GetScheduleAsXml: GetScheduleAsXml will convert the Schedul;e Definition in to Xml Format.

private XmlDocument GetScheduleAsXml(ScheduleDefinition schedule)
        {
            MemoryStream buffer = new MemoryStream();
            XmlSerializer xmlSerializer = new XmlSerializer(typeof(ScheduleDefinition));
            xmlSerializer.Serialize(buffer, schedule);
            buffer.Seek(0, SeekOrigin.Begin);

            XmlDocument doc = new XmlDocument();
            doc.Load(buffer);
            // patch up WhichWeek
            XmlNamespaceManager ns = new XmlNamespaceManager(doc.NameTable);
            ns.AddNamespace("rs",
                   "http://schemas.microsoft.com/sqlserver/2003/12/reporting/reportingservices");
            return doc;
        }
GetExtensionSettings: GetExtensionSettings function is used to set the report Delivery Setting these are common to based on Requirement.


      private ExtensionSettings GetExtensionSettings()
        {
            ParameterValue[] extensionParams = new ParameterValue[8];

            ParameterValue ToMail = new ParameterValue();
            ToMail.Name = "TO";
            ToMail.Value = Email;
            extensionParams[0] = ToMail;

            ParameterValue replyTo = new ParameterValue();
            replyTo.Name = "ReplyTo";
            replyTo.Value = string.Empty;
            extensionParams[1] = replyTo;

            ParameterValue includeReport = new ParameterValue();
            includeReport.Name = "IncludeReport";
            includeReport.Value = "false";
            extensionParams[2] = includeReport;

            ParameterValue renderFormat = new ParameterValue();
            renderFormat.Name = "RenderFormat";
            renderFormat.Value = "excel";
            extensionParams[3] = renderFormat;

            ParameterValue priority = new ParameterValue();
            priority.Name = "Priority";
            priority.Value = "NORMAL";
            extensionParams[4] = priority;

            ParameterValue subject = new ParameterValue();
            subject.Name = "Subject";
            subject.Value = txtReportName.Value;
            extensionParams[5] = subject;

            ParameterValue comment = new ParameterValue();
            comment.Name = "Comment";
            comment.Value = strComments;
            extensionParams[6] = comment;

            ParameterValue includeLink = new ParameterValue();
            includeLink.Name = "IncludeLink";
            includeLink.Value = "true";
            extensionParams[7] = includeLink;

            ExtensionSettings extSettings = new ExtensionSettings();
            extSettings.ParameterValues = extensionParams;
            extSettings.Extension = "Report Server Email";

            return extSettings;
        }

ReportServerCredentials: create class called Serializable to pass Network Credentials

[Serializable]
    public sealed class ReportServerCredentials :
        IReportServerCredentials
    {
        string _username = string.Empty;
        string _password = string.Empty;
        string _domain = string.Empty;

        public WindowsIdentity ImpersonationUser
        {
            get
            {
                return null;
            }
        }

        public ICredentials NetworkCredentials
        {
            get
            {
                _username =ConfigurationManager.AppSettings["MyReportViewerUser"].ToString();

                _password =ConfigurationManager.AppSettings["MyReportViewerPassword"].ToString();

                _domain =ConfigurationManager.AppSettings["MyReportViewerDomain"].ToString();

                char[] data = _password.ToCharArray();
                Base64Decoder myDecoder = new Base64Decoder(data);
                StringBuilder sb = new StringBuilder();

                byte[] temp = myDecoder.GetDecoded();
                sb.Append(System.Text.UTF8Encoding.UTF8.GetChars(temp));

                _password = sb.ToString();
                return new NetworkCredential(_username, _password, _domain);
            }
        }

        public bool GetFormsCredentials(out Cookie authCookie,
                    out string userName, out string password,
                    out string authority)
        {
            authCookie = null;
            userName = null;
            password = null;
            authority = null;

            // Not using form credentials
            return false;
        }

    }