Hi friends,
I would appreciate that if anyone can share the idea to
bring up ' 0' after SQL query returns null in Report 2.5 ?
What I mean is in Report 2.5, if I have four SQL queries and each query
will returns each quarterly data and I need to display ' 0' even though
there
is no records return for the 2nd quarter.
My report now can display data like below and the SQL query is
/* select count(rain_days), count(sunshine_days) from weather
where quarter='2' */ and the return is null
quarter qtr1 qtr3 qtr4
rain days # 20 15 25
sunshine days# 10 15 5
I want to have report can display like below even though my SQL query
/* select count(rain_days), count(sunshine_days) from weather
where quarter='2' */
returns null
quarter qtr1 qtr2 qtr3 qtr4
rain days # 20 0 15 25
sunshine days# 10 0 15 5
Thanks.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Hsu, Anthony C., ,CPMS
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).