We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date
  1. Home
  2. Forum
  3. ASP.NET MVC
  4. Trying to Display an RDL Report with it's own built in Dataset
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.

Trying to Display an RDL Report with it's own built in Dataset

Good Day,

I have RDL files which have their own specified datasets and datasources within the RDL file. I've been able to have them displayed with your ASP .Net report viewer BUT I'm having trouble getting it to display with the MVC control. Seems as though the MVC control needs you to specify the dataset in code rather than use the dataset specified in the rdl file?

Please confirm and let me know if there is a workaround for this. We want users to be able to create their report and upload it into our system so we can run and display it. This means we cannot write code to build each dataset for the MVC control and would like it to take the dataset specified in the rdl file

1 Reply
YD Yuvaraj Devarajan Syncfusion Team August 10, 2017 06:55 AM UTC

Hi Anil, 

Thanks for contacting Syncfusion Support. 

In ASP.Net MVC ReportViewer, if we specify the datasource connection string detail in RDL report under datasource property as shown in shared screenshot then the report data is rendered from datasource service without passing the dataset value in code behind. We suspect the mentioned issue might have occurred when you have specified the processing mode as local to load the RDL file in your application. So please specify the processing mode as “Remote” to load the RDL report in your application to avoid the mentioned problem as shown in below code example, 

<body style="overflow: hidden; position: static; margin: 0px; padding: 0px; width: 100%; height: 100%"> 
        <div style="width:100%; height:100%; position:absolute;"> 
            @(Html.EJ().ReportViewer("reportsample") 
               .ProcessingMode(Syncfusion.JavaScript.ReportViewerEnums.ProcessingMode.Remote) 
               .ReportServiceUrl(VirtualPathUtility.ToAbsolute("~/api/ReportApi")) 
                       .ReportPath("~/App_Data/GroupingAgg.rdl")                 
            ) 
        </div> 
 
    </body> 

DataSource connection property, 
 

For your reference, we have prepared a sample and it can be downloaded from below location, 

Please refer the below UG documentation to create ReportViewer sample in ASP.NET MVC platform, 

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

If the issue persists, then share the RDL file and view page to validate the mentioned issue at our end. 

Regards, 
Yuvaraj D. 


Loader.
Live Chat Icon For mobile
Up arrow icon