Reports Question: putting a 0 where count() returns nothing

From: <beyer_at_my-dejanews.com>
Date: Wed, 04 Nov 1998 15:33:45 GMT
Message-ID: <71ps4q$vip$1_at_nnrp1.dejanews.com>

Hi, I have been working on a report, I have it set up as a matrix report and for each worker ID I am counting how many times they ran a form. Well some workers have ran some forms at all so when I count(frm_typ_cd) it leaves a space where the number would be normally returned. See example below:

Forms 100 200 300 400 500

---

wrkr

0001        1                5       6       2
0002                 17      1       20      2
0003        1         7      9              17

What I would like to do is fill in the blanks with a 0 (zero) so that it may look better but I have not been able to figure out a suitable way yet. I was wondering if any reports guru out there has a solution to this. Any help would be much appreciated. BTW we are using Reports 2.5.

Thanks in advance!

Eric

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Nov 04 1998 - 16:33:45 CET