I am trying to use a formula to print information in the report footer section using the section expert. This is a packing slip and I need to put the items that did not ship at the bottom of the page. see example below - syntax seems to be my issue.
select sd.item, sd.custitem, sd.item_desc, sd.requested_qty, sd.total_qty
from
shipment_detail sd
where
{rpt_ShipmentPackDetails.internal_shipment_num} = sd.internal_shipment_num
select sd.item, sd.custitem, sd.item_desc, sd.requested_qty, sd.total_qty
from
shipment_detail sd
where
{rpt_ShipmentPackDetails.internal_shipment_num} = sd.internal_shipment_num