public static void Main(string[] args) { Console.WriteLine("Working..."); var reportingService2010 = new ReportingService2010(); reportingService2010.Credentials = CredentialCache.DefaultCredentials; var results = reportingService2010.ListChildren("/", true); var reportMetas = new List<ReportMeta>(); reportMetas.Add(new ReportMeta { CreatedBy = "CreatedBy", Folder = "Folder", ModifiedBy = "ModifiedBy", Name = "Name", ReportItemType = ReportItemType.Type, LastModifiedDate = "LastModifiedDate" }); foreach (var result in results) { var reportMeta = new ReportMeta(); reportMeta.Name = result.Name; reportMeta.CreatedBy = result.CreatedBy; reportMeta.ModifiedBy = result.ModifiedBy; reportMeta.LastModifiedDate = result.ModifiedDate.ToString("yyyy-MM-dd hh:mm"); reportMeta.Folder = result.Path; switch (result.TypeName) { case "Folder": reportMeta.ReportItemType = ReportItemType.Folder; break; case "Report": reportMeta.ReportItemType = ReportItemType.Report; break; case "DataSource": reportMeta.ReportItemType = ReportItemType.DataSource; break; case "Component": reportMeta.ReportItemType = ReportItemType.Component; break; case "Resource": reportMeta.ReportItemType = ReportItemType.Resource; break; } reportMetas.Add(reportMeta); } if (File.Exists(Settings.Default.TargetFile)) File.Delete(Settings.Default.TargetFile); File.WriteAllLines(Settings.Default.TargetFile, reportMetas.Select(obj => obj.ToString())); Console.WriteLine("Done!"); }
private void searchButton_Click(object sender, System.EventArgs e) { Cursor.Current = Cursors.WaitCursor; // Clear out the current descripton and path fields descriptionTextBox.Clear(); pathTextBox.Clear(); // Disable save button on new search saveReportButton.Enabled = false; // Check to see if the 'Search By' string is valid. if (conditionComboBox.SelectedIndex == -1) { MessageBox.Show( "Please select a valid 'Search By' string by clicking the drop down arrow!", "Invalid 'Search By' String", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } // Check to see if a search string is entered if (searchTextBox.Text == null || searchTextBox.Text == "") { MessageBox.Show( Resources.invalidSearchStringErrorMessage, Resources.invalidSearchStringMessageBoxTitle, MessageBoxButtons.OK, MessageBoxIcon.Error); } else { reportListView.Items.Clear(); // Create a new proxy to the web service rs = new rs2010.ReportingService2010(); rsExec = new rsExecService.ReportExecutionService(); // Authenticate to the Web service using Windows credentials rs.Credentials = System.Net.CredentialCache.DefaultCredentials; rsExec.Credentials = System.Net.CredentialCache.DefaultCredentials; // Assign the URL of the Web service rs.Url = ConfigurationManager.AppSettings["ReportingService2010"]; rsExec.Url = ConfigurationManager.AppSettings["ReportExecutionService"]; rs2010.SearchCondition[] conditions; if (conditionComboBox.SelectedIndex == NAME) { // Create Name search condition rs2010.SearchCondition condition = new rs2010.SearchCondition(); condition.Condition = rs2010.ConditionEnum.Contains; condition.ConditionSpecified = true; condition.Name = "Name"; string[] val = {searchTextBox.Text}; condition.Values = val; conditions = new rs2010.SearchCondition[1]; conditions[0] = condition; } else if (conditionComboBox.SelectedIndex == DESC) { // Create Description search condition rs2010.SearchCondition condition = new rs2010.SearchCondition(); condition.Condition = rs2010.ConditionEnum.Contains; condition.ConditionSpecified = true; condition.Name = "Description"; condition.Values[0] = searchTextBox.Text; // Add conditions to the conditions argument to be used for // FindItems conditions = new rs2010.SearchCondition[1]; conditions[0] = condition; } else { // Create Name rs2010.SearchCondition nameCondition = new rs2010.SearchCondition(); nameCondition.Condition = rs2010.ConditionEnum.Contains; nameCondition.ConditionSpecified = true; nameCondition.Name = "Name"; nameCondition.Values[0] = searchTextBox.Text; // Create Desription rs2010.SearchCondition descCondition = new rs2010.SearchCondition(); descCondition.Condition = rs2010.ConditionEnum.Contains; descCondition.ConditionSpecified = true; descCondition.Name = "Description"; descCondition.Values[0] = searchTextBox.Text; // Add conditions to the conditions argument to be used for // FindItems conditions = new rs2010.SearchCondition[2]; conditions[0] = nameCondition; conditions[1] = descCondition; } try { // Return a list of items based on the search conditions that // apply rs2010.Property[] SearchOptions = new rs2010.Property[1]; rs2010.Property SearchOption = new rs2010.Property(); SearchOption.Name = "Recursive"; SearchOption.Value = "True"; SearchOptions[0] = SearchOption; returnedItems = rs.FindItems("/", rs2010.BooleanOperatorEnum.Or, SearchOptions, conditions); if (returnedItems != null && returnedItems.Length != 0) { foreach (rs2010.CatalogItem ci in returnedItems) { //Create a ListView item containing a report catalog item if (ci.TypeName == "Report") { // Add the items to the list view CatalogListViewItem newItem = new CatalogListViewItem(ci); reportListView.Items.Add(newItem); } } } else MessageBox.Show( Resources.noItemsFoundInfoMessage, Resources.noItemsFoundMessageBoxTitle, MessageBoxButtons.OK, MessageBoxIcon.Information); } catch (Exception exception) { HandleException(exception); } finally { Cursor.Current = Cursors.Default; } } }
private void ConnectToServer() { // Init UI EnableButtons(true); this.Path = Root; string serverPath = serverPathTextbox.Text; try { // Connect to Reporting Services Cursor.Current = Cursors.WaitCursor; rs = new rs2010.ReportingService2010(); // A production application would perform a complete check on the url path this.Connect(serverPath); // Display root items DisplayItems(Path); } catch (Exception ex) { EnableButtons(false); this.HandleGeneralException(ex); } finally { Cursor.Current = Cursors.Default; } }
public void Connect(string url) { // Create an instance of the Web service proxy and set the Url property rs = new rs2010.ReportingService2010(); rs.Credentials = System.Net.CredentialCache.DefaultCredentials; soapUrl = url + wsdl; rs.Url = soapUrl; }
public ReportDeployment(ReportingService2010 rs) { _rs = rs; }
public ReportDeployment() { _rs = new ReportingService2010 {Credentials = Credentials, Url = Url}; }
public ReportManager2010(string url, string userName, string password) { ReportingService = new ReportingService2010(); InitializeSSRS(url, userName, password); }
public void Connect(string url) { this.m_service = new ReportingService2010(); this.m_service.Credentials = this.Credentials; this.m_url = url; this.m_soapUrl = this.m_url + wsdl; this.m_service.Url = this.m_soapUrl; }