Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: Execute A query for each row

  1. #1
    Join Date
    Apr 2010
    Posts
    14

    Default Execute A query for each row

    hello,

    I have a report and a subreport what i want to do, it's put my sub report (which is some kind of summary) after each row (Details Body-Details), and this summary is in function of current row, so i want to be able passe some data from current row (Id for example) to my sub report.

    Thanks in advance.

  2. #2
    Join Date
    Mar 2003
    Posts
    8,085

    Default

    Add the subreport to your itemband. Use the subreports parameter to get data in.
    Get the latest news and tips and tricks for Pentaho Reporting at the Pentaho Reporting Blog.

  3. #3
    Join Date
    Apr 2010
    Posts
    14

    Default

    i have already done that, but my problem is how passing the current line data to the sub report.

    REPORT
    Line 1 : ID=100 NAME=SOMEONE
    Sub report :
    Some data from some table WHERE USER_ID=100

    Line 2 : ID=101 NAME=SOMEONE
    Sub report :
    Some data from some table WHERE USER_ID=101

    Line 3 : ID=102 NAME=SOMEONE
    Sub report :
    Some data from some table WHERE USER_ID=102

    I created, the parameters and imported them into my Sub report, it's ok, but how can passe the ID value (100, 101 and 102) for each line into my sub report

    Thanks in advance,

  4. #4
    Join Date
    Nov 2009
    Posts
    687

    Default

    F.E. In sub report the parameter Par1 = ID from the main report
    Some data from some table WHERE USER_ID=${Par1}

  5. #5
    Join Date
    Apr 2010
    Posts
    14

    Default

    Thanks

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.