Hitachi Vantara Pentaho Community Forums
Results 1 to 3 of 3

Thread: generate SQL Query in Xaction and use it in Birt?

  1. #1
    Join Date
    Jan 2008
    Posts
    3

    Default generate SQL Query in Xaction and use it in Birt?

    Okay, here we go :-).
    I´ve got a little problem let me explain it.
    I get some user inputs in my xaction, now i use javascript to generate a sql statement in string format in my xaction.

    How can I use this String as SQL Query in my Birt report.

    So I want to:
    Generate a String in my xaction which contains a SQL Query.

    So far so good.

    And how can I now use this String as Query, so I get my shiny little Birt Report generated with die SQL Query i made in the xaction?

    Sorry for my bad english, but I hope you understand what I mean und perhaps can help me? :-)

    Alex

  2. #2

    Default

    I guess your query will return a fixed result set, that fits into an existing report structure, is that correct?
    If so, you will have to modify the .rptdesign file with some java code, xslt or whatever to check for a property-tag with a "queryText" name-attribute, and replace the existing query with your generated one.

  3. #3
    Join Date
    Jan 2008
    Posts
    3

    Default

    Thanks for your answer now it works fine :-).
    Alex

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.