I am trying to suppress dates from (wrkordr.wrkdate) in my report. The data field is left outer joined to (wrkitem.itemnbr) to give me the correct date corresponding with that line. I have a string that separates Labor and Materials and I would like to remove the dates from the Materials. It looks at (wrkitem.itemtype) 0 is labor or 3 materials. I tried

if {wrkitem.itemnbr} > 1
then 0
Else {wrkordr.wrkdate}

This gives a boolean error

I click on the data link and Select Expert than Formula Editor and add it there is this correct?



Edited by Twizik - 25 Apr 2012 at 10:47am

I would like to exclude dates that fall under the item type field 3 which is Miscellaneous. I only want to see dates for the labor line items. I cannot return a date field with an If statement tho.....

select statements (in the select expert) are boolean evaluations of each row of data and if-then is not needed (nor IMO should it be used). If the result of the evaluation is TRUE then the row is included, if it is FALSE it is excluded.

what do you mean by "...I added this to the select expert on the workdate data field ..."?

click on show formula (in the select expert window)

Edited by DBlank - 26 Apr 2012 at 5:21am