Telerik blogs

Here’s how to use the Embedded Web Report Designer to create the reports you need right in the applications where you’ll use them.

This probably sounds familiar: You’re working in an application and need additional information—specifically, you need to view a report with the data you need to make a good decision. So you leave your application, surf over to some reporting system, find the report, check the data … and then come back to the application you just left to actually “do the work.”

In a better world, that report would be available from your application and you wouldn’t have to leave the application to get the information you need. Telerik Report Viewer lets you do that.

But that report will only be useful if it has the information you need—and no one knows better than you what that information should be. In that better world, you’d create the report you need. If the developers who are building your applications have embedded the Telerik Web Report Designer into your application, then you can do that, too, and (like viewing your report) do it without leaving your application. Once you’ve created your report, you can then access it from within your application whenever you need it.

You don’t even have to start creating your report from scratch because the Telerik Web Report Designer will let you enhance an existing report that, perhaps, isn’t quite right to create the report you really need.

Now, this would be the ideal world.

Getting Started

It’s up to your application’s developers where and how Telerik Report Designer will be made available in your application (the designer could open with a mouse click on a button, from a menu choice, through clicking on a hyperlink or, really, through any interaction with your application).

When the designer appears, it will probably show you, in design mode, the last report used in the application (if there is no report yet defined for the application, the report designer will show a new, blank report).

A screenshot of the Web Report Designer. On the left is a panel with two tabs labelled Components and Explorer. Explorer tab is displayed showing a TreeView with multiple nodes. In the middle is a rectangular area divided into three horizontal sections. On the right is another panel divided into multiple sections with headings, dropdown lists and textboxes. Many of the sections in the panel have arrows, indicating they can be expanded.

Now you have a choice—you can either modify an existing report or create a new one.

Starting a new report is easy: Click on the hamburger menu in the upper left corner of the Report Designer menu (it’s conveniently labeled “Menu”) and select the New Report menu choice. That will open the Create a Report dialog. In the dialog, enter the name you want to give your report and click the Save button to create your report.

The report designer, with the Menu box in the top left corner selected and showing the menu dropped down with the menu’s choices. The New choice is selected.

If you decide to use an existing report as the start point for your new report, you can either enhance the report being displayed or pick another report. To pick another report, first click the dropdown button by the name of the currently displayed report to get a list of available reports and then pick the report you want to use as your start point.

The top left corner of the report designer menu. The Menu button is still visible but to its right is the name of a report. On the right of the report name is a dropdown arrow (this arrow is circled), A dropdown list showing two report names is displayed below the report name.

Hint: If you start creating your new report by modifying an existing report then, after you’ve picked the report you want to start with, click on the hamburger menu again and use the Save As command to save the report under a new name.

The hamburger Menu in the upper right corner displayed again but, this time, the Save As choice is selected.

After all, if a report is a good starting point for one new report, it could easily be the start for another new report. By using the Save As option, you ensure that old report will stick around so you can use it as the base for some other report. In addition, by using Save As you protect yourself: If your changes don’t work out for you, you can always reopen the original report and start over.

Connecting to Data

Regardless of how you get your report started, you’re going to need some data. That can be one of your organization’s databases or a CSV (Excel) file or a variety of other data sources. To see what data sources have been set up for you, just click on the Explorer tab in the panel left of the main designer window, just below the hamburger menu.

The top of the panel on the left side of the data source, showing two tabs. The right hand tab marked Explorer is selected (and circled). The tab shows a TreeView with the node named Shared Data Sources selected

In the TreeView on that tab, find the Shared Data Sources Option, and then click on the three dots to its right. That will reveal a menu with an Add Existing Shared Data Source menu choice.

The Shared Data Sources node from the TreeView showing the three dots to its right inside a circle. A single menu choice is displayed below it to its right that says Add Existing Shared Data Source.

Click on the Add Existing Shared Data Source menu choice to show the data sources that have been set up for you. You can pick a data source based on its name or its description (and don’t worry if you pick the wrong data source, you can always change your mind later and switch to another data source). If you’re not sure which data source will work for your report, you can contact the developer who set up the report designer in your application to help you decide which data source is your best choice.

A new dialog labelled Browse for Folder. A panel on the left shows a single, selected choice named Shared Data Sources. The main area on the right shows two document icons labelled Northwind All Tables.sdsx and Northwind.sdsx. One of the document icons has been selected. In the bottom right corner of the dialog there are Save and Cancel buttons.

Once you’ve picked a data source, click on the data source to select it and then click on the Save button to attach the data source to your report. You’ll be taken back to the Explorer tab which will now show the fields from that data source that you can use in your report.

The Explorer tab again. However, a new node has been added under the Shared Data Sources node. The new node is named Northwind All Tables1. Below it is a list of column/field names from tables in the Northwind database.

It’s very likely that the developers who created your application will have set up the report designer with data sources relevant to the application you’re working in. If you can’t find a data source that works for the report you want, you can create a new data source. However, you’ll probably need to enlist the support of your IT department to do that (especially if you want to connect to one of your organization’s databases).

But, for now: Congratulations! You’re ready to start creating your report. As you create your report, you’ll want to see how you’re doing. To preview your report as you work, just click the Preview button in the upper right corner of the report. When your report is displayed, that Preview button will change to a Design button—just click that button to return to designing your report.

Ready to Take Advantage of Embedded Reporting?

Progress Telerik Reporting provides all the tools you need to embed the rich, interactive reports your users need in order to analyze and understand their data right into your users’ applications (including letting your users export the results into more than 15 formats, either to distribute or integrate with other analysis tools). Telerik Reporting then lets you go further and empower your users with a fully functional Web Report Designer to create the reports they want without ever leaving the applications where they’ll use their reports.

You can leverage these easy-to-use tools in both any client-side web application environment (HTML5/JS, Angular, React, Vue or Blazor) and any .NET application (web or desktop: ASP.NET Core, ASP.NET MVC, ASP.NET AJAX, WinForms and UWP).

If you still have not tried it, you can start a free trial to take a closer look. A renowned support service and an array of resources will help you along the way.


Peter Vogel
About the Author

Peter Vogel

Peter Vogel is a system architect and principal in PH&V Information Services. PH&V provides full-stack consulting from UX design through object modeling to database design. Peter also writes courses and teaches for Learning Tree International.

Related Posts

Comments

Comments are disabled in preview mode.