Reporting.dll 1.0.24

Reporting

.NET Reporting

Install-Package Reporting.dll -Version 1.0.24
dotnet add package Reporting.dll --version 1.0.24
<PackageReference Include="Reporting.dll" Version="1.0.24" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add Reporting.dll --version 1.0.24
The NuGet Team does not provide support for this client. Please contact its maintainers for support.

Reporting

Drop in reporting tool with sql query builder

Typical use:

<asp:Button ID="btnToggleEditing" runat="server" OnClick="btnToggleEditing_Click" Text="Toggle report editing" />
<br />
<%@ Register assembly="Reporting" namespace="Reporting" tagprefix="DTI" %>
<DTI:ReportSelector ID="ReportSelector1" runat="server"></DTI:ReportSelector>

Code behind:

protected void btnToggleEditing_Click(object sender, EventArgs e)
{
	Reporting.Report.isGlobalAdmin = !Reporting.Report.isGlobalAdmin;
	Response.Redirect(Request.Url.AbsoluteUri);
}

Web.config:

<add name="ConnectionString" connectionString="Data Source=SQLServerName;Initial Catalog=WhereTheDataIs;Integrated Security=True" providerName="System.Data.SqlClient"/>

Note: THIS WILL ADD TABLES TO THE DATABASE. If you want to use SQLite to store the reports set the report connection like:
In Global.asax.cs

protected void Session_Start(object sender, EventArgs e)
{
	Reporting.Report.ReportDataConnectionShared = BaseClasses.DataBase.createHelperFromConnectionName("CONNECTION NAME").defaultConnection;
}

Reporting

Drop in reporting tool with sql query builder

Typical use:

<asp:Button ID="btnToggleEditing" runat="server" OnClick="btnToggleEditing_Click" Text="Toggle report editing" />
<br />
<%@ Register assembly="Reporting" namespace="Reporting" tagprefix="DTI" %>
<DTI:ReportSelector ID="ReportSelector1" runat="server"></DTI:ReportSelector>

Code behind:

protected void btnToggleEditing_Click(object sender, EventArgs e)
{
	Reporting.Report.isGlobalAdmin = !Reporting.Report.isGlobalAdmin;
	Response.Redirect(Request.Url.AbsoluteUri);
}

Web.config:

<add name="ConnectionString" connectionString="Data Source=SQLServerName;Initial Catalog=WhereTheDataIs;Integrated Security=True" providerName="System.Data.SqlClient"/>

Note: THIS WILL ADD TABLES TO THE DATABASE. If you want to use SQLite to store the reports set the report connection like:
In Global.asax.cs

protected void Session_Start(object sender, EventArgs e)
{
	Reporting.Report.ReportDataConnectionShared = BaseClasses.DataBase.createHelperFromConnectionName("CONNECTION NAME").defaultConnection;
}

Release Notes

Adding webactivator to add startup script

Version History

Version Downloads Last updated
1.0.24 69 4/2/2019
1.0.23 52 4/2/2019
1.0.22 66 3/7/2019
1.0.21 67 2/21/2019
1.0.20 148 10/16/2018
1.0.19 129 10/16/2018
1.0.18 100 10/16/2018
1.0.17 211 5/23/2018
1.0.16 152 5/23/2018
1.0.15 205 3/15/2018
1.0.14 206 3/14/2018
1.0.13 247 2/8/2018
1.0.12 226 2/2/2018
1.0.10 247 2/1/2018
1.0.7 218 1/30/2018
1.0.5 214 12/19/2017
1.0.1 200 12/19/2017