Search results for query: *

Thank you so much for your help!!!!! After all of this your first post was accurate what was tripping me up was SECURITY of all things. Apparently I did not have access to "BLANK" values in the F0006. So when I tried to return a blank MCMCU security prohibited me from viewing the record. That...

I am able to return the value if I Left outer join the F03b11 to the F0006, and in my select expert set Rpdoc = 307769. then my report returns the following. Doc Business unit RPDOC = 307769 RPMCU = 1014 If i add MCMCU to the detail section of the report this record no...

I tried your new formula with still the same result. Here is the example of what I am trying to return. I am wondering if I truely am trying to return a NULL value? in the f03b11 i have a Document # 307769 whose RPMCU is 1011. In the f0006 the MCMCU 1011 does not exist. So is it correct...

The report is not returning any results if I use the ISNULL statement. If i do not use this statement all valid values are being returned from the F03b11 are being returned. Currently in the F03b11 there are records that do not match the f0006 in the MCMCU, therefore I would expect to see these...

this is what is showing in my SHOW SQL QUERY SELECT F03B11."RPDOC", F03B11."RPMCU", F0006."MCMCU" FROM { oj "WPD7333"."F03B11" F03B11 LEFT OUTER JOIN "WPD7333"."F0006" F0006 ON F03B11."RPMCU" = F0006."MCMCU"} WHERE F0006."MCMCU" IS NULL this is what came from the...

It still is not working, I reran the report after Unchecking the boxes as directed. I am trying to return two fields from file A. Document Number and Business Unit. Dave

I am trying to find descrepencies between two files. File A (F03b11). is left outer linked to file B (F0006). I am trying to return the values from the primary File A. that do not exist in the Linked file B. I have linked the field which I am trying to find the execption. File A...