1. Home
  2. Forum
  3. ASP.NET MVC
  4. System.FormatException
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.

System.FormatException

Hello support team,

 

I'm trying to display a SSRS report, but I get the following exception in the browser (see below).

 

I can open the report from the SharePoint server and it works.

I can also call other reports from my WebApi/JavaScript Solution and they are working also, but this one not.

 

Technologies:

- MS Web API with .Net Framework 4.7

- JavaScript Essentials 1

- SSRS Reports that are hosted in SharePoint 2013 Server (on prem)

 

Error message from the browser:

---------------------------

Meldung von Webseite

---------------------------

_reportLoaded:Sf_Exception - System.InvalidOperationException: Fehler im XML-Dokument (2,3789). ---> System.FormatException: Die Zeichenfolge '=IIF(ROUND(AVG(IIF(Fields!KPIX_SYSTEM_CODE.Value = "K003", Fields!KPI_VALUE.Value, Nothing)))>0,True, False)' kein gültiger Boolean-Wert.

   bei System.Xml.XmlConvert.ToBoolean(String s)

   bei Microsoft.Xml.Serialization.GeneratedAssembly.XmlSerializationReaderReportDefinition.Read126_ChartDataLabel(Boolean isNullable, Boolean checkType)

   bei Microsoft.Xml.Serialization.GeneratedAssembly.XmlSerializationReaderReportDefinition.Read129_ChartDataPoint(Boolean isNullable, Boolean checkType)

   bei Microsoft.Xml.Serialization.GeneratedAssembly.XmlSerializationReaderReportDefinition.Read139_ChartSeries(Boolean isNullable, Boolean checkType)

   bei Microsoft.Xml.Serialization.GeneratedAssembly.XmlSerializationReaderReportDefinition.Read143_ChartData(Boolean isNullable, Boolean checkType)

   bei Microsoft.Xml.Serialization.GeneratedAssembly.XmlSerializationReaderReportDefinition.Read182_Chart(Boolean isNullable, Boolean checkType)

   bei Microsoft.Xml.Serialization.GeneratedAssembly.XmlSerializationReaderReportDefinition.Read261_Rectangle(Boolean isNullable, Boolean checkType)

   bei Microsoft.Xml.Serialization.GeneratedAssembly.XmlSerializationReaderReportDefinition.Read262_Body(Boolean isNullable, Boolean checkType)

   bei Microsoft.Xml.Serialization.GeneratedAssembly.XmlSerializationReaderReportDefinition.Read267_ReportSection(Boolean isNullable, Boolean checkType)

   bei Microsoft.Xml.Serialization.GeneratedAssembly.XmlSerializationReaderReportDefinition.Read301_ReportDefinition(Boolean isNullable, Boolean checkType)

   bei Microsoft.Xml.Serialization.GeneratedAssembly.XmlSerializationReaderReportDefinition.Read302_Report()

   --- Ende der internen Ausnahmestapelüberwachung ---

   bei Syncfusion.RDL.Data.ReportModel.ProcessReport()

   bei Syncfusion.EJ.ReportViewer.ReportViewerLayoutModel.LoadReport()

   bei S…

---------------------------

OK  

---------------------------

 

the corresponding section from the report file:


=IIF(ROUND(AVG(IIF(Fields!KPIX_SYSTEM_CODE.Value = "K003", Fields!KPI_VALUE.Value, Nothing)))>0,True, False)


My Web Service:

 

JavaScript:




I would like to identify why it does not work. May I request your assistance?


1 Reply
YD Yuvaraj Devarajan Syncfusion Team January 29, 2018 08:33 AM UTC

Hi TheAnonymousModeIT, 

Thanks for contacting Syncfusion support. 

We have tested the mentioned problem with your shared expression and its working properly at our end. In which, we have specified the expression (“=IIF(ROUND(AVG(IIF(Fields!KPIX_SYSTEM_CODE.Value = "K003", Fields!KPI_VALUE.Value, Nothing)))>0,True, False)”) in tablix cell visibility and its working properly in our ReportViewer. So can you please share the issue reproducible RDL file an Essential studio build version to validate the mentioned problem at our end. For your reference, we have prepared a demo sample and it can be downloaded from below location,  

Regards, 
Yuvaraj D. 


Loader.
Up arrow icon