There’s been some questions floating through the Pentahoshpere (I think I’m the first person to use that word, btw) about how to use Subreports. I think there’s a good description at the wiki that covers the basics, but I don’t think there’s a good working example that is shipping with Pentaho open source yet.
I don’t really have time to delve into all of it so in the spirit of “early and often” I’ll just post the zip file with a working example (on 1.6 GA Designer and Server).
Here tis:
http://nicholasgoodman.com/entry_images/pentaho_subreport_example.zip
Are you aware of any examples that have a master report that holds a header, one or many subreports(with their own header, ie. column headings), and a master report footer(ie a report disclaimer of some sort). Am having issues, for example with getting the master’s footer appearing at the bottom of all pages, not just the last page.
thanks
Yeah. I don’t think that will work since the Subreport page header footers override the master reports.
Hmmmm….
Hello nicholas,
Sorry i can’t speak english very well.
I’m using pentaho and i found your web.
I’ve read the pentaho’s wiki, but i don’t find a example that i have a parameter with many subreports.
I’ve tried to use your example but I could not make it work.
Can you help me??? my email is konsillere@yahoo.es
Thanks a lot.
Hi
I used your example but an error appear to me while I an executing the second query :
COULD NOT FETCH THE QUERY METADATA
REASON:
ERROR: SYNTAX ERROR AT OR NEAR “$”
waiting your response
thanks
Hello, I need to run the examples to realize the configuration parameters for the queries, but the example does not work.
as entering the parameters of the subreport?
Thanks a lot
I’m using the pentaho classic engine (JFreeReport) to show reports from java.
I can run this example at the Report Designer, but how i can do it from java?.
Thanks, for your attention
estoy usando report designer 2.0 y tengo el problema de que el subinforme quiero imprimirlo en todas las paginas del reporte no solo en la primera lo he puesto en la seccion de page header pero marca error.
si me podrias ayudar a resolver mi problema con el subreporte, por favor
gracias…
hi,
i am beginning the step reporting. i found the example report “sales by productline” is very well. for example the top report is about “sales by territory”, and then we can choice another report by clic “product lines” or “produit” and so on. can you give an example in this sujet?
thanks
helene
@Amee
What database are you using. I have the same problem and I using PostgreSQL
Hi,
Will you please provide more information on parameter passing and xaction files