Subreports Example Zip

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

10 thoughts on “Subreports Example Zip

  1. Bob

    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

    Reply
  2. Jose Antonio

    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.

    Reply
  3. Amee

    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

    Reply
  4. john

    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

    Reply
  5. vlad

    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

    Reply
  6. zhuni

    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…

    Reply
  7. helene

    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

    Reply

Leave a Reply to Nicholas Goodman Cancel reply

Your email address will not be published. Required fields are marked *