public void Setup()
 {
     sut = new MsReportingServices("http://mock.url", "mock", "mock", "mock");
     mockEmailSubInfoContents = new List <string>
     {
         "subscriptionOn,true",
         "eventType,TimedSubscription",
         "scheduleXml,<ScheduleDefinition xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\"><StartDateTime xmlns=\"http://schemas.microsoft.com/sqlserver/reporting/2010/03/01/ReportServer\">2012-12-11T05:45:00.000+00:00</StartDateTime><MonthlyRecurrence xmlns=\"http://schemas.microsoft.com/sqlserver/reporting/2010/03/01/ReportServer\"><Days>1</Days><MonthsOfYear><January>true</January><February>true</February><March>true</March><April>true</April><May>true</May><June>true</June><July>true</July><August>true</August><September>true</September><October>true</October><November>true</November><December>true</December></MonthsOfYear></MonthlyRecurrence></ScheduleDefinition>",
         "subjectPrefix,Test Report",
         "emailBodyText,Your report is attached",
         "subscriptionSendTo,[email protected]",
         "subscriptionBCCto,[email protected]",
         "reportParameters,daterangetype=month"
     };
     mockFileShareSubInfoContents = new List <string>
     {
         "subscriptionOn,true",
         "eventType,TimedSubscription",
         "scheduleXml,<ScheduleDefinition xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\"><StartDateTime xmlns=\"http://schemas.microsoft.com/sqlserver/reporting/2010/03/01/ReportServer\">2012-12-11T05:45:00.000+00:00</StartDateTime><MonthlyRecurrence xmlns=\"http://schemas.microsoft.com/sqlserver/reporting/2010/03/01/ReportServer\"><Days>1</Days><MonthsOfYear><January>true</January><February>true</February><March>true</March><April>true</April><May>true</May><June>true</June><July>true</July><August>true</August><September>true</September><October>true</October><November>true</November><December>true</December></MonthsOfYear></MonthlyRecurrence></ScheduleDefinition>",
         "subscriptionType,FILESHARE",
         "subscriptionRenderFormat,CSV",
         @"subscriptionToFile_FilePath,\\ftpShare\Reporting",
         @"subscriptionToFile_UserName,ftpUserName",
         "subscriptionToFile_Password,IMAPASSWORD",
         "subscriptionToFile_FileName,Test_Report",
         "reportParameters,daterangetype=month"
     };
 }
Пример #2
0
        private static void DeployReportingServiceRole(MsReportingServices msreports)
        {
            var itemPath = GetReportingVariable("itemPath");
            var reportingUserToAddRoleFor = GetReportingVariable("reportingUserToAddRoleFor");
            var reportingRoleToAdd        = GetReportingVariable("reportingRoleToAdd");

            msreports.AddRole(itemPath, reportingUserToAddRoleFor, reportingRoleToAdd);
        }
Пример #3
0
        public void Setup()
        {
            //var reportingServicesUrl = "http://LOC-POPERINGE/ReportServer/ReportService2010.asmx";
            var reportingServicesUrl = "http://btn-rs01.15b.local/ReportServer_NON1/ReportService2010.asmx";
            var loginDomain          = "15below";
            var loginUser            = "******";
            var loginPassword        = "";

            sut = new MsReportingServices(reportingServicesUrl, loginDomain, loginUser, loginPassword);
        }
Пример #4
0
        private static void PublishReports(MsReportingServices msreports)
        {
            var parentFolder               = GetReportingVariable("parentFolder");
            var subFolder                  = GetReportingVariable("subFolder");
            var dataSourceName             = GetReportingVariable("dataSourceName");
            var dataSourceConnectionString = GetReportingVariable("dataSourceConnectionString");
            var dataSourceUserName         = GetReportingVariable("dataSourceUserName");
            var dataSourcePassword         = GetReportingVariable("dataSourcePassword");
            var reportSourceFolder         = GetReportingVariable("reportSourceFolder");

            msreports.PublishReports(parentFolder, subFolder, dataSourceName, dataSourceConnectionString, dataSourceUserName, dataSourcePassword, reportSourceFolder);
        }
Пример #5
0
        internal static void RunReportingServices()
        {
            var reportingServicesUrl = GetReportingVariable("reportingServicesUrl");
            var networkDomain        = GetReportingVariable("networkDomain");
            var networkLogin         = GetReportingVariable("networkLogin");
            var networkPassword      = GetReportingVariable("networkPassword");
            var msreports            = new MsReportingServices(reportingServicesUrl, networkDomain, networkLogin, networkPassword);

            if (Arguments.DeployReportingRole)
            {
                DeployReportingServiceRole(msreports);
            }
            if (Arguments.DeployReports)
            {
                PublishReports(msreports);
            }
        }