Reporting engines with good postgresql support
I have an upcoming project in which reports will play a large role.  The reports will be predefined in nature, but may return significant amounts of data.  For the database portion of the project we've settled on PostgreSQL, but we're still debating about what stack of software to use for the frontend.  

The reports are a significant enough piece of the puzzle that strong reports support may swing us one way or the other.  In a previous project we've used Oracle and Crystal together. However, we're not big Crystal fans and would like to avoid it, if possible.

My big concern is that a large result set would have to be materialized first in order the generate the report and multiple users trying to materialize too many large sets at once would hurt (we ran into this problem initially in Crystal with another application).  In Crystal and Oracle, we could return a cursor and Crystal would read the data in from the cursor.  Do any other reporting systems have support for reading result sets from a returned PostgreSQL refcursor? 

I'm reasonably familar with BIRT and have a passing notion of JasperReports but can't seem to identify if its possible in either.


Reporting engines with good postgresql support
===

I have an upcoming project in which reports will play a large role.  The reports will be predefined in nature, but may return significant amounts of data.  For the database portion of the project we've settled on PostgreSQL, but we're still debating about what stack of software to use for the frontend.  

The reports are a significant enough piece of the puzzle that strong reports support may swing us one way or the other.  In a previous project we've used Oracle and Crystal together. However, we're not big Crystal fans and would like to avoid it, if possible.

My big concern is that a large result set would have to be materialized first in order the generate the report and multiple users trying to materialize too many large sets at once would hurt (we ran into this problem initially in Crystal with another application).  In Crystal and Oracle, we could return a cursor and Crystal would read the data in from the cursor.  Do any other reporting systems have support for reading result sets from a returned PostgreSQL refcursor? 

I'm reasonably familar with BIRT and have a passing notion of JasperReports but can't seem to identify if its possible in either.

