Notifications
Clear all
Topic starter
Does anyone know of a table you can use in Crystal Reports to get a list of which orders are included in each custom list. Thank you!
Posted : April 20, 2021 7:22 am
I've used CUSTOMORDERS & QPICKS tables linking CUSTOMORDERS.GID to QPICKS.QPID
My report tells me the qpicktype, ordertype, order code, & order description. I am thinking if this is the same thing you are referring to here & for CEMR.
Posted : April 20, 2021 8:23 am
Topic starter
I'll look into that. Thank you!
Posted : April 20, 2021 8:25 am
Topic starter
This got me exactly what I needed. Thank you so much! I never would have thought to look in "QPICKS"
Posted : April 20, 2021 8:42 am
Great, glad that I could help!
Posted : April 20, 2021 8:47 am
Here's some straight SQL to get Custom Order Sets:
select q.qpicktype,q.description,o.ordcodeid,o.ordertype,o.code,o.description
from customorders o, qpicks q
where o.gid = q.qpid
order by q.qpicktype,q.description,o.ordertype
Posted : April 20, 2021 9:03 am
