Notifications
Clear all
Topic starter
Good morning, I am needing a report of our Custom order lists. Before trying to recreate the wheel, thought I would reach out to see if anyone might already have one that they have made and would be willing to share. We are currently on CPS 12.3.2.
Thanks,
Linda
Posted : January 18, 2019 4:08 am
You could use this with SQL, I have never bothered to make anything into "nice" formatting with crystal reports, but this will export the data you desire.
You can throw the data into Excel then filter based off of the custom list name. This can also be modified to tell you what custom lists an order is on.
select q.DESCRIPTION, c.DESCRIPTION,c.CODE from CUSTOMORDERS c
INNER JOIN QPICKS q on q.QPID = c.GID
--where q.DESCRIPTION = '*OUTSIDE CARDIAC/PULMONARY'
ORDER BY SORTID
Posted : January 21, 2019 2:52 am
Topic starter
Thanks so much! I'll see if they will be happy with that!
Posted : January 21, 2019 5:57 am
