I forgot to mention that I am running 4.10.1
Anderson, I put the original report back in place. And this did work.
I'm wondering what I could have done to the report to keep from printing.
The only thing that I can think of is the itemloc table that I am pulling in to see how much qty I have of the item. Any Ideas?
SELECT ls_number, ls_notes,
formatlotserialnumberbarcode(ls_number) AS lotserial_barcode,
item_number, item_descrip1, item_descrip2,
charass_char_id, charass_value, char_name, formatqty(itemloc_qty) as lotqty
JOIN item ON (item_id=ls_item_id)
JOIN itemloc ON (ls_id = itemloc_ls_id)
LEFT JOIN charass ON (charass_target_id=ls_id)
LEFT JOIN "char" ON (char_id=charass_char_id)
WHERE ls_id=<? value("ls_id") ?>;