DeleteReportSet

default

markdown

#DeleteReportSet()

[[_TOC_]]

##Preface

The DeleteReportSet method is used to delete reports from your storage system. This method can be overridden in your [[CustomAdHocConfig|http://wiki.izenda.com/Integration/Tutorials/Customizing-Izenda-Settings]] class.

##Usage
If you have overwritten [SaveReportSet()](http://wiki.izenda.com/FAQ/SaveReportSet) to change the location where reports are saved, it is necessary to use this override to indicate where the deletion will occur.

##Examples
The code samples below demonstrate method of overriding the method to implement custom functionality using both [[DatabaseAdHocConfig|http://wiki.izenda.com/FAQ/Storing-Reports#Database-Mode]] and [[FileSystemAdHocConfig|http://wiki.izenda.com/FAQ/Storing-Reports#File-System-Mode]].

### C# DatabaseAdHocConfig Sample

```csharp
public override void DeleteReportSet(string reportName)
    {
      try
      {
        string connectionString = @"Persist Security Info=False;Initial Catalog=Northwind;Data Source=LESHA-PC\SQL2012;User ID=dataLogin;Password=dataPassword;Integrated Security=false;";
        string sql = string.Format(@"DELETE FROM {1} WHERE Name='{0}'", reportName.Trim(), AdHocSettings.SavedReportsTable);
        using (System.Data.IDbConnection connection = new System.Data.SqlClient.SqlConnection(connectionString))
        {
          connection.Open();
          using (System.Data.IDbCommand command = connection.CreateCommand())
          {
            command.CommandText = sql;
            command.ExecuteNonQuery();
          }
        }
      }
      catch
      {
      }
    }
```

### C# FileSystemAdHocConfig Sample

```csharp
public override void DeleteReportSet(string reportName)
    {
      try
      {
        string filePath = System.IO.Path.Combine(ReportPath, reportName);
        System.IO.File.Delete(filePath + ".xml");
      }
      catch
      {
      }
    }
```

### VB.NET DatabaseAdHocConfig Sample
```visualbasic
Public Overrides Sub DeleteReportSet(reportName As String)
      Try
        Dim connectionString As String = "Persist Security Info=False;Initial Catalog=Northwind;Data Source=LESHA-PC\SQL2012;User ID=dataLogin;Password=dataPassword;Integrated Security=false;"
        Dim sql As String = String.Format("DELETE FROM {1} WHERE Name='{0}'", reportName.Trim(), AdHocSettings.SavedReportsTable)
        Using connection As System.Data.IDbConnection = New System.Data.SqlClient.SqlConnection(connectionString)
          connection.Open()
          Using command As System.Data.IDbCommand = connection.CreateCommand()
            command.CommandText = sql
            command.ExecuteNonQuery()
          End Using
        End Using
      Catch ex As Exception
      End Try
    End Sub
```

### VB.NET FileSystemAdHocConfig Sample
```visualbasic
Public Overrides Sub DeleteReportSet(reportName As String)
      Try
        Dim filePath As String = System.IO.Path.Combine(ReportPath, reportName)
        System.IO.File.Delete(filePath + ".xml")
      Catch ex As Exception
      End Try
    End Sub
```

Uploading file...

Header

Sidebar

![Izenda Logo](http://izenda.com/wp-content/uploads/2014/12/IzendaNewLogoBlueTR.png)

---

* [[Izenda 7 Series Documentation|https://www.izenda.com/docs/]]
* [[Release Notes]]
* [[Upgrade Best Practices|FAQ/Izenda-Update-Best-Practices]]
* [[FAQ]]
* [[Tutorials]]
* [[The Izenda API|/API/AdHocConfig]]
* [[The AdHocSettings class|/API/AdHocSettings]]
* [Developer Links and Guides](/Guides/Developer-Links-and-Guides)
* [[Known Issues]]

---

* <a href="http://www.izenda.com" rel="nofollow" target="_blank">Izenda Website</a>
* [Product Video](https://www.youtube.com/watch?v=X3-yWFq0w5A)
* <a href="http://www.izenda.com/blog" rel="nofollow" target="_blank">Izenda Blog</a>
* <a href="http://www.izenda.com/company/" rel="nofollow" target="_blank">About Us</a>
* <a href="http://www.izenda.com/contact-us/" rel="nofollow" target="_blank">Contact Us</a>

---
* [Guide To Report Design](/Guides/ReportDesign)
* [Making Custom Forms Video](http://www.youtube.com/watch?v=5b2axJlgdFs)

---

* [[Acknowledgements]]

Edit message:

Cancel

Editing DeleteReportSet

Header

Sidebar