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

Hi

This solution is recommended in the Building Reports manual. Create a static text with and "0" in it, and put it *behind* the field in the matrix cell, which you have set to be filled with white. In the cells without result, the "0" will be visible, while in the others it will be covered with the result itself! Very dummy, isnt it?

Good Luck
Luis Cabral

beyer_at_my-dejanews.com wrote:
>
> 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 Fri Nov 06 1998 - 22:10:14 CET