Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: I pass parameters to a subreport

  1. #1

    Default I pass parameters to a subreport

    hi!!!!!!!

    How can I pass parameters to a subreport? I tried but I have not had success

  2. #2
    pstoellberger Guest

    Default

    Add subreport element > click on it > look at properties > click on the "...." next to PARAMETERS and insert your parameters

  3. #3

    Default

    Thanks for answering, i'll explain, the main report has the first 10 customers and the subreport has those client's products, but when the i set the 'where' condition/clause of the data of the subreport to where=${client} y gives me a symbol error, i'd apreciated any help to from the main report to subreports

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

    Default

    A where=? is probably not a correct SQL statement, so your JDBC driver refuses to work with that query. A parameter can only replace values, it can never replace column names or whole where conditions.

    Your where clause should be a valid SQL condition in the format of "SELECT <columns> FROM <table> WHERE columname=${parameter}"
    Get the latest news and tips and tricks for Pentaho Reporting at the Pentaho Reporting Blog.

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.