Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Who printed that order?

Status
Not open for further replies.
Jan 20, 2003
291
US
I have a requirement to create a Crystal report to track open pick tickets by who printed them, where they printed at and when. I can get the who and when out of the audit log but where is proving to be a challenge. I have looked at the system event log but 1) I really don't want to turn on that level of auditing and 2) in testing, it does not appear to track Macola print ticket jobs.
We use one specific printer at each branch location for all the multi-part pick tickets. While they can be printed anywhere, it is only these we are interested in tracking currently.

Open to any suggestions at this point on how to identify the printer.
 
To my knowledge Macola won't do this natively. Intuitively, I can't imagine an off-the-shelf third party app that could do this.

I suppose a trigger in SQL server could manage this. Either that, or you could employ Flexibility.
 
One idea would be to check the print defaults file for the current default printer for the pick ticket print job for a particular user. If a user uses the print dialog to dynamically select the printer each time that they print a job, and the user may print to multiple printers, then this method will not work. I may be able to scrape together an alternate method for you if you are not able to get the data from the print defaults table, but it can take some time and I need to know that it is needed before I spend the time.

Scott Travis
NEXO Systems, Inc.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top