Wow this was a bizarre one…as i need to stress the crystal report was never modified or touched in the first place!
and i still don’t really get it…but…
as the data was there in the crystal report, but not showing anything (data was also in the XML file)…we decided to
- make all the connections outer left join.
some of the data came back apart from the Qty field…
we changed the formula to:
IF {MtlQueue.Quantity} > 1 AND {PartAllocSerial.SerialNum} <> ‘’
THEN 1
ELSE {MtlQueue.Quantity}
and then the data came back for that field too.