Oracle 91 related Reporting Question

I have a database that has no values for a certain month, how do I display “0” for the months that do not have values? My status summary report runs against Oracle 9i.

Please help ASAP!


sotellmewhy (BOB member since 2002-11-06)

I have an even better idea. How about you help yourself. Use the BOB search feature and look for “all month*” or “missing month*” or similar. We’ve discussed this topic several times in the past. Lots of innovative solutions if I remember correctly.


Dwayne Hoffpauir :us: (BOB member since 2002-09-19)