How to add custom data-extension for Web Report Designer in ASP.NET application
The Syncfusion Web Report Designer has a support to access the custom data extension.
Refer to the following documentation link to create a Report Designer sample in ASP.NET.
Getting Started documentation.
Please find the below steps to add the Web API DataExtension sample in our Web Report Designer sample.
Step1: Add the Web API Extension project reference to our Web Report Designer sample as shown in below snap:
Step2: Add the configuration section in AppConfig or WebConfig file as shown in below code example.
App.config
<?xml version="1.0" encoding="utf-8" ?> <configuration> <configSections> <section name="ReportingExtensions" type="Syncfusion.Reporting.Extensions, Syncfusion.Report.Portable" allowLocation="true" allowDefinition="Everywhere" /> </configSections> <ReportingExtensions> <DataExtension> <Extension Name="WebAPI" Assembly="Syncfusion.Reporting.DataExtensions.WebAPI" Type="Syncfusion.Reporting.DataExtensions.WebAPI.WebAPIExtension"> <Properties> <Add Key="QueryDesignerEnabled" Value="true"/> <Add Key="QueryFilterEnabled" Value="false"/> <Add Key="QueryExpressionEnabled" Value="false"/> <Add Key="QueryJoinerEnabled" Value="false"/> <Add Key="QueryColumnEdit" Value="false"/> </Properties> </Extension> </DataExtension> </ReportingExtensions> </configuration>
Step3: Set the ReportDataExtension property in Default.aspx.cs file shown in below code example.
Default.aspx.cs
protected void Page_Load(object sender, EventArgs e)
{
this.ReportDesigner1.ServiceUrl = VirtualPathUtility.ToAbsolute("~/api/ReportDesigner");
var ReportDataExtension = new Syncfusion.JavaScript.Models.ReportDesigner.ReportDataExtensionsModule();
ReportDataExtension.Name = "WebAPI";
ReportDataExtension.ClassName = "WebAPIDataSource";
ReportDataExtension.ImageClass = "e-reportdesigner-datasource-webapi";
ReportDataExtension.DisplayName = "WebAPI";
this.ReportDesigner1.ReportDataExtensions.Add(ReportDataExtension);
}
Default.aspx
<body> <form id="form1" runat="server" onsubmit="return false" style="overflow: hidden; padding: 0; margin: 0; height: 100%; width: 100%;"> <ej:ReportDesigner runat="server" ID="ReportDesigner1" ServiceUrl="../api/ReportDesigner"> </ej:ReportDesigner> </form> </body> </html>
You can download the sample from the following location.
Sample
http://www.syncfusion.com/downloads/support/directtrac/general/ze/ReportDesignerSample-1680759305
