ReportViewer Division by zero

reportviewer

I have some formulas in my reports, and to prevent divsion by zero I do like this in the expression field:

=IIF(Fields!F1.Value <> 0, Fields!F2.Value/Fields!F1.Value, 0)

This normally works fine, but when both F1 and F2 are zero, I get "#Error" in the report, and I get this warning: "The Value expression for the textbox ‘textbox196’ contains an error: Attempted to divide by zero."

Why is that?

Best Solution

There has to be a prettier way than this, but this should work:

=IIF(Fields!F1.Value <> 0, Fields!F2.Value / 
   IIF(Fields!F1.Value <> 0, Fields!F1.Value, 42), 0)

Related Solutions

C# – ReportViewer IIf expression in text box returns #ERROR

Calling ToString() on a null value goes Kaboom. Try IsNot Nothing instead.

But I think the real answer is here.

Vb.net – Reportviewer Missing Datasource

For one you are not setting the processing mode to local

Here is code that works, when I create the report I make sure to have the datasource name in the report correspond to the table name of my dataset, not sure if that is required but it keeps things simpler.

       _reportViewerNewContracts.ProcessingMode = Microsoft.Reporting.WinForms.ProcessingMode.Local
        _reportViewerNewContracts.LocalReport.ReportPath = "Reports\NewContractsReport.rdlc"

        Dim reportDataSource1 As New Microsoft.Reporting.WinForms.ReportDataSource()
        reportDataSource1.Name = _contractDataset.NewContracts.TableName
        'Name of the report dataset in our .RDLC file
        reportDataSource1.Value = _contractDataset.NewContracts

        Me._reportViewerNewContracts.LocalReport.DataSources.Add(reportDataSource1)
        'fill data 
        _reportViewerNewContracts.RefreshReport()

(I have seen lots of sites that recommend the datasetname underscore tablename but that never worked for me)

Best Solution

Related Solutions

C# – ReportViewer IIf expression in text box returns #ERROR

Vb.net – Reportviewer Missing Datasource

Related Question