Re: Matrix Report Headache
From: Alan D. Mills <alanm_at_uk.europe.mcd.mot.com>
Date: 1998/11/03
Message-ID: <71n60g$qv8$1_at_schbbs.mot.com>#1/1
Date: 1998/11/03
Message-ID: <71n60g$qv8$1_at_schbbs.mot.com>#1/1
unless you can get away with an outer join or use of NVL as previously suggested you might want to try a little bit of pre-processing of data just before your report. Something along the lines of adding a false zero entry for each month just to ensure there's at least one record for each month in range making sure it appears on the report. This would work as long as you are not counting records but just summing them by month.
-- Alan D. Mills Thenardier_at_POBoxes.com wrote in message <71mttr$u4s$1_at_nnrp1.dejanews.com>...Received on Tue Nov 03 1998 - 00:00:00 CET
>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!
>