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)
Edit data in a report
bhushanbn
<p>Hi,</p><p>I'm new to BIRT and was lloking if we can edit the data displayed in the report.</p><p>I'm using Oracle database and the requirement is to edit the data in the report and save back the edited data to database.</p><p>Please help me on this.</p>
Find more posts tagged with
Comments
shir
<p>It all depends on what data are u trying to edit.</p><p> </p><p>If i understand correctly you are trying to "format" the data which you have</p><p> </p><p>Dpending on the type of data, you can find on properties tab options of `Format Number`, `Format dateTime` and `Format String`, you can use either depending on your requirement.</p><p> </p><p>Further you have BIRT and and Native JavaScript functions which you can utilize to edit/format the data.</p><p> </p><p>As far as inserting records you can do this by the beforeClose method and you prefabricate your insert query in a variable.</p><p> </p><p>I am not too sure about the insert as i have not tried it out myself</p>
bhushanbn
<p>Thanks for the reply!!!</p><p>This is not regarding the format of data.</p><p>I want to modify the data presented in the report and save it back to database. Will it be possible in BIRT?</p>
shir
<p>can you provide some examples as what do u mean by modify data, and as far as data insert, we can do it, however you have to do some research and members too will help you out</p>
pricher
<p>Hi,</p><p> </p><p>There is nothing out of the box in BIRT that will let you save modified data in a database. However, it is relatively easy to build a solution based on a servlet that will take data from a report and post it to a database. I have created a reference example a few years ago that was posted as a devshare: <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><p> </p><p>Hope
this helps,</p><p> </p><p>P.</p>
bhushanbn
<p>Thanks for that
@Pricher
..</p><p>But how will the user edit data presented in the report?</p>
pricher
<p>Hi,</p><p> </p><p>Sorry for the late response. Here's another example that shows how to embed a text editor in a report and save the content to a database:</p><p><a data-ipb='nomediaparse' href='
http://developer.actuate.com/community/forum/index.php?/files/file/724-framework-for-adding-comments-to-a-birt-report/'>http://developer.actuate.com/community/forum/index.php?/files/file/724-framework-for-adding-comments-to-a-birt-report/</a></p><p> </p><p>Hope
this helps,</p><p> </p><p>P.</p>