1. Home
  2. Forum
  3. ASP.NET MVC
  4. 71/5000 How to create a report with a data source coming from the MVC controller
Starting in 2019, the Reporting control is no longer included in Essential Studio®. If you're experiencing issues with the Syncfusion� Reporting Platform, Report Viewer, Report Designer, or Report Writer, we recommend migrating to Bold Reports, our dedicated reporting platform.

Bold Reports offers a comprehensive suite of tools and features for all your reporting needs, and we will help you make a smooth transition from the discontinued control. Our support team at https://support.boldreports.com/ is here to assist you with any questions or difficulties you may encounter during the migration process.

We thank you for choosing Syncfusion� and appreciate your understanding.

71/5000 How to create a report with a data source coming from the MVC controller

Hi!
55/5000
I searched the following page to create a report: https://help.syncfusion.com/report-platform/reportdesigner/getting-started

I would like to create a report in which the data source will be a list of an object coming from the controller method.
For example, I want to create a customer report for a particular vendor.
So, I have the following method in the controller:

List <Customer> GetCustomers (int vendorId)
{
     List<Customer> list = new List<Customer>();

     ...

     return list;
}

Could you help me to carry out this development?

Thank you!

Junior

20 Replies
VS Vinoth Srinivasan Syncfusion Team July 21, 2017 12:02 PM UTC

Hi Carlos, 
 
Thanks for your interest in Syncfusion Components. 
 
You can create a report using list of objects as datasource using our WPF report designer. The RDLC DesignMode in ReportDesigner allows you to use business objects as datasource in reports. We have prepared a sample based on this and it can be downloaded from the following location. 
 
 
Also, we have prepared a video demo for creating a new report in our report designer using list of objects as datasource for your reference and it can be downloaded from the following location. 
 
 
Please refer our online UG documentation for more details on this. 
 
 
Regards, 
Vinoth S. 


CJ Carlos Junior July 26, 2017 04:49 PM UTC

Excuse me! But I want to open reports from my web application (ASP.NET MVC). What do I use to build these reports? Remembering that when you open the reports, the data will come from a list (List ) coming from the controller. I still do not understand the steps to build and open the reports in a web application. Thanks! Junior

YD Yuvaraj Devarajan Syncfusion Team July 27, 2017 12:26 PM UTC

Hi Carlos, 

Thanks for the update. 

We can visualize/render the designed RDL/RDLC file with the local datasource value from the WebAPI controller in our Web based (ASP.NET MVC/ASP.NET) ReportViewer component as shown in below code example. 

WebAPI: 
        public void OnReportLoaded(ReportViewerOptions reportOption) 
        { 
            reportOption.ReportModel.DataSources.Clear(); 
            reportOption.ReportModel.DataSources.Add(new ReportDataSource { Name = "Sales", Value = SalesDetails.GetData() }); 
        } 
 
Please refer to the below UG documentation link to create a ReportViewer application in ASP.NET MVC platform, 

you can obtain the ASP.NET MVC ReportViewer sample in below build installed location, 
%userprofile%\AppData\Local\Syncfusion\EssentialStudio\version\ MVC\Samples\web 

Currently, we have a standalone ReportDesigner application to build/design the report in WPF platform and it’s not available in Web platforms (ASP.NET & MVC). We have already logged feature report for “Providing ReportDesigner control in web Platform” and it is available in Volume 4, 2017 release which is tentatively scheduled to be released in the month of October.  

Regards, 
Yuvaraj D. 


CJ Carlos Junior July 31, 2017 02:15 PM UTC

Thanks, Yuvaraj!Attached is the report I'm trying to modify.This report has a Dataset called "remote" with the following fields:CustomerId, EmployeeId, Freight, OrderId, ShipCity, and ShipCountry.How do I add more fields to the remote dataset?Another question: How do I create fields in a Dataset without using Query Designer?Como o Dataset "remote" foi criado para este arquivo rdlc?Thanks!JuniorAttachment: reportRdlc_631402f3.rar

CJ Carlos Junior July 31, 2017 08:06 PM UTC

Excuse me!
The last question I wrote in Portuguese.
The correct one would be: How was the "remote" dataset created for this rdlc file?


YD Yuvaraj Devarajan Syncfusion Team August 1, 2017 10:59 AM UTC

Hi Carlos, 
 
Thanks for your interest in Syncfusion Components. 
 
You can create report with datasource and dataset without query string using our report designer in RDLC design mode. You need to create a class object with required fields to achieve your requirement. We have prepared a sample and video demo based on your requirement and it can be downloaded from the following location. 
 
 
 
Please refer to the below UG documentation link for more detail, 
 
Regards, 
Yuvaraj D. 


CJ Carlos Junior August 1, 2017 01:38 PM UTC

Hi Yuvaraj,
Actually, it's difficult for me to understand how to build a new RDL / RDLC file.
In the example you sent me, the class object is developed in a desktop application and my application is web (ASP.NET MVC).
In the video, I see that the report designer connects to the project. How do I do this?
My report designer is different from the one used in the video.
Attached is the image of my report designer.

Regards,
Junior


Attachment: reportDesigner_d9275035.rar

YD Yuvaraj Devarajan Syncfusion Team August 2, 2017 12:39 PM UTC

Hi Carlos, 
 
We can see from the shared image that you are using report designer executable application used for creating RDL, with that you cannot able to design the report using class objects. In our previous update we have provided a standalone WPF report designer application project to create report from the class objects by changing the DesignMode property to RDLC. We request you to use the standalone report designer application to design the report using class objects and you can use those report in your ASP.NET MVC report viewer. Please refer the below help documentation for providing datasource to the report in ASP.NET MVC 
 
Also, you can use Visual Studio to create a RDLC report with business objects. Please refer the below MSDN documentation for more details. 
 
Regards, 
Vinoth S. 


CJ Carlos Junior August 2, 2017 01:25 PM UTC

Ok, Vinoth!
Can you send me the link for me to download the standalone report designer application?

Thank you very much!
Junior


YD Yuvaraj Devarajan Syncfusion Team August 3, 2017 12:17 PM UTC

Hi Carlos, 

Thanks for the update. 

In previous updates, we have already shared the standalone WPF report designer application project and it can be downloaded from below location, 

Regards, 
Yuvaraj D. 


CJ Carlos Junior August 9, 2017 02:27 PM UTC

Hi, Yuvaraj!

I would like to download the "Syncfusion Essential Report Designer" software.
Is there a link for me to download it?

Thank you!
Junior


YD Yuvaraj Devarajan Syncfusion Team August 10, 2017 06:11 AM UTC

Hi Carlos, 

Thanks for the update. 

In Syncfusion Essential studio dashboard, the ReportDesigner application is located under “ADD-ONS” tab and when we click the Report Designer icon the WPF ReportDesigner component is loaded in your machine as shown in below screenshot,  

 

You can obtain the ReportDesigner component exe file in below build installed location, 
C:\Program Files (x86)\Syncfusion\Essential Studio\ version\Utilities\Report Designer 

Also, you can download our latest Essential Studio Volume 3, 2017 (Version 15.3.0.26) under the following link. 

Regards, 
Yuvaraj D. 


CJ Carlos Junior August 11, 2017 01:48 AM UTC

Hi, Yuvaraj!
I would like to have the same version of "Syncfusion Essential Report Designer" that you use in the video you sent me to create the report using class objects.
Only that.

Thank you!
Junior


YD Yuvaraj Devarajan Syncfusion Team August 11, 2017 01:28 PM UTC

Hi Carlos, 

The ReportDesigner utility application provided in our Essential Studio build supports to create RDL reports only. Since, your requirement is to create report using class objects, it can be achieved only using the RDLC mode, due to this we had provided the procedure and utility application to use the RDLC design mode. The RDLC designer can be downloaded from the following location. 

Regards, 
Yuvaraj D. 


CJ Carlos Junior August 11, 2017 02:13 PM UTC

Hi, Yuvaraj!
Unfortunately, I am not able to understand how to create rdlc reports.
I just wanted software to create rdlc reports. I do not know how to use the project you sent me in link to build new rdlc reports.
When I try to create by visual studio, the Report Wizard template does not appear for me to create a new rdlc report.
Can you send me the software that is used in the video you sent me so I can create rdlc reports?

Thank you!
Junior


YD Yuvaraj Devarajan Syncfusion Team August 14, 2017 11:52 AM UTC

Hi Carlos, 
 
Thanks for the update. 
 
We would like to setup a web meeting to look into it and provide a solution for your requirement. So, a support incident to track the status of this future has been created under your account. Please log on to our support website to check for further updates. 
https://www.syncfusion.com/account/login?ReturnUrl=%2fsupport%2fdirecttrac%2fincidents

Regards, 
Yuvaraj D. 


CJ Carlos Junior August 23, 2017 03:19 AM UTC

Hi Yuvaraj,

My problem has been solved.
Thank you very much!

Regards,
Junior

YD Yuvaraj Devarajan Syncfusion Team August 23, 2017 04:22 AM UTC

Hi Carlos, 
  
Thanks for the update. We are happy to hear that your issue is resolved.  
  
Regards,  
Yuvaraj D.  


JO johseffer August 21, 2018 12:31 PM UTC

How this problem has been solved?

MM Mageshyadav M Syncfusion Team August 22, 2018 11:33 AM UTC

Hi Johseffer, 

We have provided the steps to create a RDLC file using our WPF ReportDesigner and You can create a report using .NET business list objects as datasource for the report in our report designer in RDLC design mode. We need to create a class with required properties to achieve this requirement. We have prepared a sample and video demo based on this, it can be downloaded from the following location.  

  

Also, please refer the below help documentation link for more details  


Regards, 
Mageshyadav.M 


Loader.
Up arrow icon