Report 2.5, how to bring up ' 0 ' when sql query returns null ?

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

Re: Report 2.5, how to bring up ' 0 ' when sql query returns null ?

Hey, Go to Metalink site and enter 29736.1 in the search box. Hopefully, that document will help you. --- "Hsu, Anthony C., ,CPMS" [EMAIL PROTECTED] wrote: 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 ?