filtering in reports

Gaurav Singhal

<p>Hi,</p><p> </p><p>I am new to birt. I want to create a report and in the column headers implement some kind of filtering. We have thought of creating a text box in column header and allow users put in for example "A" in it. On press of filter button/label again in the report header, it should open same report with only rows starting with "A" for that column. Any suggestions how we can implement it.</p><p> </p><p>we tried using dynamic text objects and creating textbox thorugh that but then on press of button we are not able to understand how to pick value from it and then pass as drilldown in filter. we do not want to display the parameters dialog box to users.</p><p> </p><p>Thanks in advance.</p><p>Gaurav</p>

kclark

<p>Have you tried a hidden parameter and a query like this?</p><pre class="_prettyXprint">select * from customers where customername like '%" + params["filterkey"].value + "%'</pre><p>I created the following text item:</p><pre class="_prettyXprint"><script> function go() { var param = document.getElementById('filter').value; var newrpt = "http://127.0.0.1:62905/viewer/frameset?__report=%2Fhome%2Fkclark%2Fexamples%2Ffilter%2Fnew_report.rptdesign&filterkey=" + param; window.location = newrpt; }</script>Filter:<br><input type="text" id="filter"><br><input type="submit" value="Submit" onClick="go();"></pre><p>Then used this in the beforeOpen of the data set</p><pre class="_prettyXprint">if(params["filterkey"].value != "none") { this.queryText = "select * from customers where customername like '%" + params["filterkey"].value + "%'";}</pre><p>I've attached my example, enter "Ate" in the text box then click the submit button.</p>