Matrix Report Headache
Date: 1998/11/03
Message-ID: <71mttr$u4s$1_at_nnrp1.dejanews.com>#1/1
[Quoted] hi folks,
[Quoted] [Quoted] i'm working on a report which shows the total sales figures of each [Quoted] sales person for the last 12 months. i want the report to look like this:
(current mth) Name 12/1997 01/1998 02/1998 ... ... 11/1998 Total ------ ------- ------- ------- ... ... ------- ------- SalesA 10 10 20 ... ... 1 999 SalesB 10 10 20 ... ... 1 999 SalesC 10 10 20 ... ... 1 999...
u can see the month range is dynamic.
[Quoted] i know that matrix report can help me to build a report like this. my headache is, say, if there is a month in which no sales is made. (everything can happen, who know? :) ) the corresponding column will disappear! then i'll propably see 02/1998 column followed by 04/1998. but i need to show the sales figures are 0s in 03/1998!
what should i do?
[Quoted] thanx in advance.
thenard
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Nov 03 1998 - 00:00:00 CET