Re: Help with Report Design

I don't think so. The cool thing about PL/SQL is that it does it's work on the server side, then it only returns what you ask for. I checked with a couple of colleagues (including the great S. Baker himself!) and there should be no transmission of every record to your PC. Do a test. Good Luck! rq

Eric Raskin wrote:

> Robin:
>
> If I do it this way, won't I be getting every record in my customer database
> transmitted down to my PC? The whole point of the view is to do the
> counting work on the database server.
>
> Is this correct?
>
> Eric
>
> Robin Quasebarth <robinq_at_digitalpoint.com> wrote in message
> news:384BFE74.C82318A6_at_digitalpoint.com...
> > Eric, why don't you just use Oracle Reports instead of all that creating
> of
> > tables/views stuff?
> >
> > 1) Just make one query that selects the state and zip.
> >
> > 2) Then create 4 Formula Columns in that same group.
> >
> > 3) For each Formula Column go to the property sheet and go to the PL/SQL
> > Formula area. Declare a variable for your count, do your counts according
> to
> > your 4 counts in your view but tie them back to the group record with
> "zipcode
> > = :zipcode" in your where clause (or what ever you call the zipcode field
> on
> > your layout).NOTE: Remember to "return(countvariable);" that will say
> what to
> > put in your layout field for that record.
> >
> > 4) Then you can use a SIMPLE default tabular report layout. You
> definately
> > don't want to have to create tables and views everytime you have a
> slightly
> > complicated report. I think you are making it too hard.
> >
> > Robin Q
> >
Received on Mon Dec 06 1999 - 21:44:47 CET