Обсуждение: Formatted reports

Hi All,

Is there in PostgreSQL an equivalent of Oracle's BREAK/COMPUTE reporting feature?

Thanks,
SxN

2010/5/7 Sorin Schwimmer <sxn02@yahoo.com>:
> Hi All,
>
> Is there in PostgreSQL an equivalent of Oracle's BREAK/COMPUTE reporting feature?

No, there isn't.

You need some procedural language function, or use external tool to
accomplish this.
There are free reporting engines. jaspersoft, pentaho, BIRT, ...

[[ note: BREAK and COMPUTE are features of Oracle's SQL*Plus (client)
not their SQL dialect. ]]



cheers,
Filip

Definitely SQL*PLUS, you're right.

I managed to create a report as a UNION select between data and SUMs of data queries, with relevant fields for GROUPing
andORDERing. I would have liked to be able to get these "relevant fields" shown only once, so I started to check what
isavailable, and stumbled over Oracle's approach. 

I'll have a look at the suggested reporting tools.

Thanks,
SxN