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.