Count conditions do not get read properly

[yminc]

Hi,
Wonder if you would have any suggestion here. I am working on a report, need to count the rows that one of my column is not dbnull. I am using VB.net, and the expression is following

Code: Select all

{CountIf(DatadsDistinctWorkItems,(dsDistinctWorkItems.negotiated_date_due.equals(system.DBNull.Value) AndAlso (dsDistinctWorkItems.original_date_due-dsDistinctWorkItems.date_delivered).TotalMinutes>=0) orelse (Not dsDistinctWorkItems.negotiated_date_due.equals(system.DBNull.Value) andalso (dsDistinctWorkItems.negotiated_date_due-dsDistinctWorkItems.date_delivered).TotalMinutes>=0))}

Somehow, the space after Not is removed when I was trying to compile. The error is showing as:
The error of compilation
The error of compilation is found in the 'Client Activity Report by Date Delivered' report:
'NotdsDistinctWorkItems' is not declared. It may be inaccessible due to its protection level.

Thank you for your help

[Alex K.]

Hello,

Please send us your .mrt file for analysis.

Thank you.