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" }; }
private static void DeployReportingServiceRole(MsReportingServices msreports) { var itemPath = GetReportingVariable("itemPath"); var reportingUserToAddRoleFor = GetReportingVariable("reportingUserToAddRoleFor"); var reportingRoleToAdd = GetReportingVariable("reportingRoleToAdd"); msreports.AddRole(itemPath, reportingUserToAddRoleFor, reportingRoleToAdd); }
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); }
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); }
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); } }