Query Passed as parameter to report

I want to pass a query in url(as a parameter) which i can use for report generation is it possible?

If Possible please provide solution for it.Thanks in Advance

Find more posts tagged with

Comments

vishalkp

Hello Rinki,

Can u explain a bit more???

Query in URL and Report Generation, what does that mean???

bhanley

Passing a query into a report as a parameter is not likely to be a very secure option as it will be visible when the request is made. If you would like to do this you can. You can assign the parameter value to the Data Set's query in the beforeOpen scripting event. 
 
<pre class='_prettyXprint _lang-auto _linenums:0'>this.queryText = params["queryParam"].value</pre>
 
Perhaps it would be easier/more secure to just modify a part of your query based on one or more parameters? Hae a look at this DevShare item for an example. 
 
<a class='bbc_url' href='http://www.birt-exchange.org/modules/wfdownloads/singlefile.php?cid=2&lid=806'>Dynamic Query Modification - Designs & Code - BIRT Exchange</a> 
 
Good Luck!

Rinki

The Report worked perfectly.

Rinki

Can you please tell how to generate rpt in a java application by only passing Query i.e overcome the dependency of no. of parameters in dataset.