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

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