Re: Pivot Table Tool

"Hans Mayr" <mayr1972@[EMAIL PROTECTED]
> schreef in bericht 
news:4e80a1d7-6004-4fea-aeb6-acff4d43e657@[EMAIL PROTECTED]
> Hello,
>
> Is there a Windows GUI pivot table tool that has the ****tionallity of
> pivot tables in Access (user can choose which fields to use in the
> pivot table, filter the data etc.)? I could of course connect Access
> to Oracle but this would mean that Access would read a huge amount of
> data from Oracle and changes in the pivot table would be very slow.
> I'd prefer a tool that looks at the fields the user actually needs and
> creates a corresponding query doing all the grouping on Oracle. Thus
> as little computing would be done on the client's computer as possible
> and as little data would be transferd to the client.
>
> Does anybody know such a tool? Best freeware? We could of course
> programme it ourselves but if we had not have to do that work I'd be
> happy.
>
> I know that 11g offers some pivot functionality but that is not
> comfortable enough for my collegues who are not experienced with sql.
>
> Thanks and best
>
> Hans

Oracle Discoverer?

Shakespeare