Reports

[daniel bennett]

Hi all,

Just wondering would anyone know how to do a report for a ustore storefront to determine the amount of pages printed in the storefront for the past year???

The storefront uses uploaded files from customer through a document builder,

So we have thousands of orders with multiply line items on each order with different page counts on each line item, any help much appreciated thanks, Dan.

[couch]

You could query the information from the database, or create a custom report.

The # of pages in a document builder uploaded job is in the OrderProduct table, TotalNumberOfPages column. Of course you will need to multiply by the number of copies requested, and if looking for sheets instead of pages, you will have to check the product properties to see if it was single or double-sided.

Unfortunately, XMPie does not provide a schema for the database, but with a little patience, you should be able to find what you need.