generate SQL Query in Xaction and use it in Birt?

[Bluey]

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

[bamaer]

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.

[Bluey]

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