queryString - how to print onto a report

[2005 IR Help]

By: amit das - amitdas91

queryString - how to print onto a report

2004-06-03 23:05

I am trying to take the queryString value and print in directly onto my final report.

I have tried to get queryString to print as a parameter or as a variable with no luck.

 

I just want to "spit out" the final query onto my report.

 

Thanks,

Amit

 

 

 

 

By: Lucian Comanescu - lucicom

RE: queryString - how to print onto a report

2004-06-04 00:05

Hi!

 

No, you can't get it directly. But why not setting it by yourself?

 

<parameter name="SQL_QUERY" class="java.lang.String">

<defaultValueExpression>

<![CDATA["SELECT * FROM Address WHERE City NOT IN ( " + $P{FilterClause} + " ) ORDER BY " + $P{OrderClause}]]>

</defaultValueExpression>

</parameter>

 

<!-- The query string -->

<queryString>$P!{SQL_QUERY}</queryString>

 

and then you can print it like any other param.

 

Works for you?

Lucian.

 

 

 

 

 

By: amit das - amitdas91

RE: queryString - how to print onto a report

2004-06-04 10:39

Lucian,

 

Thanks! that works but one small issue.

When inserting a string parameter into the SQL_QUERY I would like to insert like:

+ $P!{FilterClause} +

instead of

+ $P{FilterClause}

 

I dont want the single quotes that automatically get appened with $P{xyx}

 

Thanks,

Amit