Home > Uncategorized > Subreports Example Zip

Subreports Example Zip

April 17th, 2008
Goto comments Leave a comment

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

Uncategorized

  1. Bob
    April 21st, 2008 at 09:50 | #1
    Reply | Quote

    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

  2. Nicholas Goodman
    April 21st, 2008 at 14:03 | #2
    Reply | Quote

    Yeah. I don’t think that will work since the Subreport page header footers override the master reports.

    Hmmmm….

  3. Jose Antonio
    May 12th, 2008 at 07:22 | #3
    Reply | Quote

    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.

  4. Amee
    July 3rd, 2008 at 02:54 | #4
    Reply | Quote

    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

  5. john
    September 11th, 2008 at 10:04 | #5
    Reply | Quote

    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

  6. vlad
    October 30th, 2008 at 09:32 | #6
    Reply | Quote

    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

  7. zhuni
    April 20th, 2009 at 11:46 | #7
    Reply | Quote

    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…

  8. helene
    May 14th, 2009 at 03:35 | #8
    Reply | Quote

    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

  1. No trackbacks yet.