ASP.NET MVC 5 Report Designer expression field resets after any change!

Hello

I have created a .rdl file which joins two data sets. In this report, there is a Grid with a column named IdentityId that has a lookup expression:

But when I try to add another column to the Grid, Report Designer resets the expression value back into:

The sample .rdl file is attached. Notice that the lookup expression is fine and works as expected in preview mode but I can no longer change the report because grid resets that lookup expression to the default field expression. You can reproduce it with the designer in installation samples. When it is hosted on IIS Express, everything is fine, but in IIS 10 this bug reproduces.

I'm running this sample on Windows 10 x64, .NET 4.5.2 and Report Designer version 16.4.0.42

Thanks in advance.

Error message: The data input collection null or empty for the data set is used in the report.

Hi Jalal, 

Thanks for your interest in Syncfusion Components. 

It is possible for your to share your report file and controller file with us. It will be helpful for us to provide the solution at the earliest. 

Regards, 

Vinoth S. 

But I have another question. Is there any way to initiate Report Viewer without setting any .rdl file? I want it to read the .rdl content from the database instead of reading it from a file.

Do you have any sample for ASP.NET MVC?

Thank you 

Hi Jalal, 

 

If your requirement is to load the report from database, then you can make use of Stream option to achieve your requirement. Please find the below code snippet for your requirement. 

 

public void OnInitReportOptions(ReportViewerOptions reportOption)          {              byte[] reportByte = null ; // Retrive the report from data base.              System.IO.MemoryStream stream = new System.IO.MemoryStream(reportByte);              reportOption.ReportModel.Stream = stream;          }

 

 

Regards, 

Vinoth S.