Reports Question

From: Wesley <www_dba_at_yahoo.com.hk>
Date: Fri, 10 Sep 1999 06:08:33 GMT
Message-ID: <7ra78s$o0i$1_at_nnrp1.deja.com>



Dear gurus,

I have a Reports problem.
I have to put a text boilerplate at the bottom of the report if no records is returned stating: No record is returned. I created a Summary Column at report level to record the total count. But in the report, I used a format trigger to screen the rows which I don't want them to be shown.
But the Summary Column only record the the total number of records retrieved eithout reducing the records removed by the format trigger. i.e. if the total record retrieved is one but it is screened by the format trigger. The No record is returned text boilerplate won't show. I tried several approachs but failed. What should I do? Thank in Advance.

Peter

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Fri Sep 10 1999 - 08:08:33 CEST

Original text of this message