Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
PUBLIC CLOUD
PRIVATE CLOUD
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Intelligence (Analytics)
putting checkbox in every row of a table
ankitvyas
<p>can anyone tell me how to add a chekbox in every row and save the rows that are checked</p>
Find more posts tagged with
Comments
GLO_FR
<p>Hi,</p><p> </p><p>y<span style="font-size:14px;">ou can put every HTML component (like a check box) with a text field</span></p><p>Simply create one in your table/report, choose the HTML format and write the html code</p><p>For instance </p><pre class="_prettyXprint"><input type="checkbox" name="save" value="save"> Save<br></pre><p>But what do you mean with "<em>Save the rows that are checked"</em> ?</p>
ankitvyas
<p>Hi <strong><span style="color:#000000;"><span style="font-family:Arial, sans-serif;">Guillaume L.,</span></span></strong></p>
<p><strong><span style="color:#000000;"><span style="font-family:Arial, sans-serif;">Thanks for the input and sorry for the late reply,by "</span></span></strong><strong><span style="color:#000000;"><span style="font-family:Arial, sans-serif;">saving the rows that are checked</span></span></strong>" i meant is i want to save those records in my database</p>
GLO_FR
<p>Hi,</p>
<p> </p>
<p>ok, this is a write-back function.</p>
<p> </p>
<p>You have a devshare there</p>
<p><a data-ipb='nomediaparse' href='
http://developer.actuate.com/community/forum/index.php?/files/file/708-birt-report-with-database-write-back/'>http://developer.actuate.com/community/forum/index.php?/files/file/708-birt-report-with-database-write-back/</a></p>
;
ankitvyas
<p>Hi <strong><span style="color:#000000;"><span style="font-family:Arial, sans-serif;">Guillaume L.</span></span></strong></p>
<p> </p>
<p><span style="color:#000000;"><span style="font-family:Arial, sans-serif;">That was really helpfull,I had one more query i.e "How do i use IN statement in my sql query"</span></span></p>
<p> </p>
<p> </p>
<p><span style="color:#000000;"><span style="font-family:Arial, sans-serif;">For eg:-consider a query "select * from user where username in ('scoot','elgin')"</span></span></p>
<p><span style="color:#000000;"><span style="font-family:Arial, sans-serif;">and i need the user to provide </span></span>these values.</p>
<p> </p>
<p>Thanks in advance,</p>
<p> </p>
<p>Regards,</p>
<p>Ankit Vyas</p>
GLO_FR
<p>Hi,</p>
<p> </p>
<p>sorry for the late answer.</p>
<p>You have to uses some JS in the BeforeOpent event</p>
<p>here is an example if you want to replace part of your query (example joined)</p>
<pre class="_prettyXprint _lang-">
myQuery = this.queryText.replace("'1234'", "'"+ params["Country"].value.join("','") + "'");
this.queryText = myQuery;
</pre>
<p>BTW, you can also create your query dynamically</p>
<pre class="_prettyXprint _lang-js">
myWhereStatement = "WHERE **** IN ('"+ params["Country"].value.join("','") + "')");
​this.queryText += myWhereStatement;
</pre>
