Re: Report No Data Found
Date: Fri, 3 Nov 2000 17:36:09 -0500
Message-ID: <g5HM5.54060$Z2.776048_at_nnrp1.uunet.ca>
Hi!
That's right, it is possible to use Summary Column with Function = Count and Reset at = Report and then before report trigger.
To check record set before invocation of report with queries that are more then one page I think it is better to use Ref Cursors. In this case you will have a big query in one place. For this you need to create database package with function that returns ref cursor type based on your query, create ref cursor query in Report Designer, then before report invocation use packaged function to initiate cursor variable, fetch it and use attribute %notfound to find out whether result set is not empty. Examples on how to do this can be found in Reports documentation.
Best regards
"Eric Givler" <egivler_at_flash.net> wrote in message
news:A0GM5.4940$pq3.336529_at_news.flash.net...
> a computed formula to count the rows of the report. Reference it's
results
> in the before-report trigger and display an error if it isn't > 1.
> (srw.message). The return a false to exit.
>
> OR, count the records prior to calling it based on the proper selection
> criteria.
>
> <perkinsdt_at_my-deja.com> wrote in message
news:8tuj42$b44$1_at_nnrp1.deja.com...
> > I am tring to capture that No Data was returned in a report query and
> > display an alert and return to the calling form without displaying the
> > empty report on screen.
> > Any Ideas?
> > Diane Perkins
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
>
>
Received on Fri Nov 03 2000 - 23:36:09 CET