Custom Reports - Am I missing something

Mar 31, 2008 3 Replies

Hi there - I'm a real newbie. We are running v2. I can't seem to create any sort of custom reports - beyond modifying the filters of standard reports (eg. custom date range for a detailed sales report).


I'd like to do things like add in additional fields to a report (that aren't available in the show/hide columns). For example, one of the dimensions in our matrix / item properties is "Gender" - Male/Female. I'd like to run a report that breaks down sales on a given day / period based on sales between men/women.. This data is certainly stored against every record we have.

Can someone please point me in the right direction?

Wow - How to write your own custom reports on day 1!!! I love it.

The info you are after is stored in the Item (HQ and SO), ItemDynamic (HQ) and DailySales (HQ and SO).

Also - you will see a lot of community pooling of common thoughts, ideas, processes and reports requests.

Good luck - and have a great day!!!

available in the show/hide columns). For example, one of the dimensions in our matrix / item properties is "Gender" - Male/Female. I'd like to run a report that breaks down sales on a given day / period based on sales between men/women.. This data is certainly stored against every record we have.

aren't available in the show/hide columns). For example, one of the dimensions in our matrix / item properties is "Gender" - Male/Female. I'd like to run a report that breaks down sales on a given day / period based on sales between men/women.. This data is certainly stored against every record we have.

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required