You can integrate Report Designer with Report Server to create, edit, browse and publish reports using the Report Server built-in API service.
Follow this steps to integrate Report Server with Bold Reports Designer version higher than
v5.2.xx
Right-click the project or solution in the Solution Explorer tab, and choose Manage NuGet Packages. Alternatively, select the Tools > NuGet Package Manager > Manage NuGet Packages for Solution menu command.
Refer to the NuGet Packages to learn more details about installing and configuring Report Designer NuGet packages.
Search for BoldReports.Web
and BoldReports.WebForms
NuGet packages, and install them in your Web Forms application.
Package | Purpose |
---|---|
BoldReports.Web |
Creates Web API service for processing the reports. |
BoldReports.WebForms |
Contains tag helpers to create client-side web Report Designer control. |
Open Web.config
file and add the BoldReports.WebForms
assembly reference to the <system.web.pages.controls>
element with SF
tag prefix.
<configuration>
....
....
<system.web>
....
<pages>
....
<controls>
<add assembly="BoldReports.WebForms" namespace="BoldReports.WebForms" tagPrefix="Bold" />
....
</controls>
</pages>
</system.web>
....
....
</configuration>
Install the BoldReports.JavaScript
nuget package into your application.
BoldReports.JavaScript
- contains Report Designer scripts and style sheets.The scripts and styles required for web Report Designer will be added into the Scripts
and Content
folders of your application.
Refer to the Dependencies to learn more details about web Report Designer dependent scripts and style sheets links.
You can use the following code in the <asp> tag of Default.aspx
page.
<asp:Content ID="BodyContent" ContentPlaceHolderID="MainContent" runat="server">
<link href="Content/bold-reports/v2.0/tailwind-light/bold.report-designer.min.css" rel="stylesheet" />
<link href="Scripts/CodeMirror/lib/codemirror.css" rel="stylesheet" />
<link href="Scripts/CodeMirror/addon/hint/show-hint.css" rel="stylesheet" />
<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.6.0/jquery.min.js"></script>
<script src="Scripts/CodeMirror/lib/codemirror.js"></script>
<script src="Scripts/CodeMirror/addon/hint/show-hint.js"></script>
<script src="Scripts/CodeMirror/addon/hint/sql-hint.js"></script>
<script src="Scripts/CodeMirror/mode/sql/sql.js"></script>
<script src="Scripts/CodeMirror/mode/vb/vb.js"></script>
<!-- Report Designer component dependent scripts -->
<script src="Scripts/bold-reports/v2.0/common/bold.reports.common.min.js"></script>
<script src="Scripts/bold-reports/v2.0/common/bold.reports.widgets.min.js"></script>
<!-- Report Viewer and Designer component scripts -->
<script src="Scripts/bold-reports/v2.0/bold.report-viewer.min.js"></script>
<script src="Scripts/bold-reports/v2.0/bold.report-designer.min.js"></script>
</asp:Content>
Initialize the web Report Designer as shown in the following code sample in the Default.aspx
page.
<asp:Content ID="BodyContent" ContentPlaceHolderID="MainContent" runat="server">
<link href="Content/bold-reports/v2.0/tailwind-light/bold.report-designer.min.css" rel="stylesheet" />
<link href="Scripts/CodeMirror/lib/codemirror.css" rel="stylesheet" />
<link href="Scripts/CodeMirror/addon/hint/show-hint.css" rel="stylesheet" />
<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.6.0/jquery.min.js"></script>
<script src="Scripts/CodeMirror/lib/codemirror.js"></script>
<script src="Scripts/CodeMirror/addon/hint/show-hint.js"></script>
<script src="Scripts/CodeMirror/addon/hint/sql-hint.js"></script>
<script src="Scripts/CodeMirror/mode/sql/sql.js"></script>
<script src="Scripts/CodeMirror/mode/vb/vb.js"></script>
<!-- Report Designer component dependent scripts -->
<script src="Scripts/bold-reports/v2.0/common/bold.reports.common.min.js"></script>
<script src="Scripts/bold-reports/v2.0/common/bold.reports.widgets.min.js"></script>
<!-- Report Viewer and Designer component scripts -->
<script src="Scripts/bold-reports/v2.0/bold.report-viewer.min.js"></script>
<script src="Scripts/bold-reports/v2.0/bold.report-designer.min.js"></script>
<div style="height: 650px;width: 950px">
<Bold:ReportDesigner runat="server" ID="designer"></Bold:ReportDesigner>
</div>
</asp:Content>
The Report Designer requires the serviceAuthorizationToken
, serviceUrl
and reportServerUrl
to perform the API actions with Bold Report Server. You can provide the information from report server as like explained below,
serviceUrl
– Report Server Reporting Service information should be provided for this API.
serviceAuthorizationToken
– Authorization token to communicate with reportServiceUrl.
reportServerUrl
- Report Server Reporting Server information should be provided for this API.
You can follow one of the procedure from below based on your Report Server type,
Generate token with your user credentials and assign it to serviceAuthorizationToken. You can refer to the documentation here, to generate the token by using credentials.
<div style="height: 650px;width: 950px">
<Bold:ReportDesigner runat="server" ID="designer"
ServiceAuthorizationToken="bearer <server token>" >
</Bold:ReportDesigner>
</div>
You can refer to the documentation here on how to generate the token within an application.
Set the Bold Report Server built-in service URL to the ServiceUrl
property. The ServiceUrl
property value should be in format of https://<<Report server name>>/reporting/reportservice/api/Designer
.
<div style="height: 650px;width: 950px">
<Bold:ReportDesigner runat="server" ID="designer"
ServiceUrl="https://on-premise-demo.boldreports.com/reporting/reportservice/api/Designer"
ServiceAuthorizationToken="bearer <server token>" >
</Bold:ReportDesigner>
</div>
Set the Bold Report Server built-in server URL to the ReportServerUrl
property. The ReportServerUrl
property value should be in format of https://<<Report server name>>/reporting/api/site/<<site name>>
.
<div style="height: 650px;width: 950px">
<Bold:ReportDesigner runat="server" ID="designer"
ServiceUrl="https://on-premise-demo.boldreports.com/reporting/reportservice/api/Designer"
ReportServerUrl="https://on-premise-demo.boldreports.com/reporting/api/site/site1"
ServiceAuthorizationToken="bearer <server token>" >
</Bold:ReportDesigner>
</div>
Generate token with your user credentials and assign it to serviceAuthorizationToken. You can refer the documentation here, to generate the token by using credentials.
<div style="height: 650px;width: 950px">
<Bold:ReportDesigner runat="server" ID="designer"
ServiceAuthorizationToken="bearer <server token>" >
</Bold:ReportDesigner>
</div>
You can refer to the documentation here on how to generate the token within an application.
Set the Bold Report Server built-in service URL to the ServiceUrl
property. The ServiceUrl
property value is a https://service.boldreports.com/api/Designer
.
<div style="height: 650px;width: 950px">
<Bold:ReportDesigner runat="server" ID="designer"
ServiceUrl="https://service.boldreports.com/api/Designer"
ServiceAuthorizationToken="bearer <server token>" >
</Bold:ReportDesigner>
</div>
Set the Bold Report Server built-in server URL to the ReportServerUrl
property. The ReportServerUrl
property value should be in format of https://<<Report server name>>/reporting/api/
.
<div style="height: 650px;width: 950px">
<Bold:ReportDesigner runat="server" ID="designer"
ServiceUrl="https://service.boldreports.com/api/Designer"
ReportServerUrl="https://acmecorp.boldreports.com/reporting/api"
ServiceAuthorizationToken="bearer <server token>" >
</Bold:ReportDesigner>
</div>