1. Home
  2. Forum
  3. UWP
  4. Error running report in sfReportViewer
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.

Error running report in sfReportViewer

I'm having trouble getting a specific report to run in the viewer.  Can you take a look at the attached rdl files and determine if something is wrong with the report definition.  The report has has several sub reports that also attached.  I have also attached a screenshot of the error as we see it in the viewer.  The report will preview fine directly in SSRS.

Thank you.


3 Replies
VS Vinoth Srinivasan Syncfusion Team February 5, 2018 11:36 AM UTC

Hi Ryan, 

Thanks for your interest in Syncfusion Components. 

The reported problem occurred due to the following unsupported option are used in the expression of the shared reports.  

  1. Also, you have used the following expression for textbox background color “=IIF(ROWNUMBER(NOTHING) MOD 2, "NO COLOR", "WhiteSmoke")” in all the reports. In our reporting control “NO COLOR” is not a valid color, so as of now we request you to modify the expression as following “=IIF(ROWNUMBER(NOTHING) MOD 2, " ", "WhiteSmoke")” to render the report without any issue.
  2. In “SubDefendant.rdl” you have used “Environment.NewLine” in the expression which is not supported in our reporting control.

After modifying your reports based on the above changes, we were able to render the report in our SfReportViewer using dummy data at our end. Please find the below snap based on this. 

 

Also, we have prepared a sample for this and it can be downloaded from the below location. 

However, we have logged an improvement task for the above issues and the changes will be included in our upcoming 2018 Volume1 SP1 release. 

Regards, 
Vinoth S. 


RR Ryan Richard February 9, 2018 04:56 PM UTC

Thanks for your response, instead of "Environment.NewLine", what should we use for line breaks?

AS Anandakumar S Syncfusion Team February 12, 2018 09:53 AM UTC

Hi Ryan,

You can use the vb constant VBCRLF or chr(10) instead of Environment.NewLine as shown in the below expression.
1. =First(Fields!Street.Value, "dsPeople") & VBCRLF & First(Fields!City.Value, "dsPeople")
2. =First(Fields!Street.Value, "dsPeople") & chr(10) & First(Fields!City.Value, "dsPeople"))

Regards,
Anandakumar S

Loader.
Up arrow icon