Wont show all lines

[Cpreston]

Hi

I have a report that shows schedules.

I am trying to add in a field called noofpieces.

If I add the field directly in in it only then shows the lines with a figure in the number of pieces and not all of them

There is usually a figure in the noofpieces if the=re is also a code in the packref field. If there is not an entry in the packref field then there is a not a [pack so would not be a number in the noofpieces.

Any ideas how I can get it display all lines with or without an entry either in pasckref or noofpieces. I tried a formula like below but that just shgows the ones with noofpieces.

IF {ProductPack.NoOfPieces} >=0 then {ProductPack.NoOfPieces} else 0

Hope that makes sense, any ideas please

Thanks

 

[Cpreston]

Ignore this request thanks.

I played with my joins and got it working

Thanks