Linking 1

[stevejones]

I am using a one to many relationship on my report. These are linked using a left outer join.

The tables are linked on a field called item, and if the item in the many table doesnt exist I want to compress the group header and the detail section. The detail section compresses ok because I can use the Suppress when Blank Option.

Within the formula editor I am basically trying to say

If {Table1.Itemno} <> {Table2.Itemno} Then suppress

but it doesn't work.

I am sure this is something to do with the linking as it is a pretty simple formula.

Anyone Help?

Thanks

 

[Katy44]

if you are using a left join, then "isNull({Table2.Itemno})" should work in the supress option, if you have it

 

[stevejones]

Thanks Katy44. You won't believe how many different things I tried.