Count conditions do not get read properly
Posted: Tue Nov 20, 2012 1:50 pm
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
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
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))}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