Re: Help with Report Design

Robin:

[Quoted] 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 - 20:39:14 CET