AnsweredAssumed Answered

Report or Query for Simplex, Duplex, Jobs, Sheets, Color, etc.

Question asked by Jason Pelletier on Feb 15, 2019
Latest reply on Feb 15, 2019 by Jeff Geller

We're trying to find a way to run a report, similar to the Group Printing Detail Report, but that includes a little bit more detail about the print jobs. For example, we have Jobs, Total Pages, Color Pages, Sheets and Amount Charged but we'd like to know out of that, how many are simplex and duplex black and white pages and simplex and duplex color pages. The data is in the DB because we can see that information if looking at a detail report for a specific account. We could, in theory, extrapolate or estimate the data using the Amount Charged column however, in our case, we discount staff and faculty 100% so the amount charged is actually 0 (which isn't very helpful at all).

 

Does anyone have any ideas? I'm not afraid to use a SQL query if I have to.

Outcomes