I've also built a reporting app using Cocoon, using XSP to pull back the data from Oracle and then transforming it into either a PDF report or a CSV file. A couple of tips from my experience:
- If your report includes any grouping, order your SQL query by those fields. That way you can use an <xsl:for-each> and compare each row to the previous one to determine when you have a new value. (Much simpler than the Meunch method)
I agree that you'll probably want to avoid Meunchian grouping but I'd go a step further and suggest doing your grouping in the generator if at all possible. That may sound like heresy to some, but it depends how you look at your problem, and what changes in grouping need to happen.
The esql grouping logic (should be in ESQLHelper.java or something) would be a great place to start. I've felt that would be great to refactor out into a more usable library, which would allow a simple SQLGenerator with grouping for cases where you don't need to manipulate the data very much and just want to mimic relational data in xml.
If someone provided a patch along those lines it'd be well received (at least by me!).
Geoff
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
