Framework for adding comments to a BIRT report

Migrateduser

Please note that this is just an example framework and is not intended to be production ready. Attached are the Information Console files, the library and a sample report that uses the library. This framework uses an Open Source web editor FCKEditor and MySQL database to store the comments. I would like to thank Ronny Zach for getting this started and building most of the functionality and Pierre Richer for helping me build it in to the report (instead of a separate JSP page). All I did was put it all together in a usable framework.<br />
<br />
Installation Instructions:<br />
1. Create a MySQL table using the attached SQL statement. Note you might need to change the database name depending on your environment.<br />
2. Unzip the fckeditor.zip file to C:Program FilesActuate10iPortalwebapps (or the equivalent for on-window platforms). You might need to edit line 29 in writeData.jsp to change the connection information.<br />
3. Make sure you have the MySQL jar file (mysql-connector-java-5.1.7-bin.jar) in C:Program FilesActuate10iPortalcommonlib (or the equivalent for on-window platforms). <br />
To use the library:<br />
1. Include the library<br />
2. Drag in to your design Comment Data Source. You might need to change the connection information depending on your environment.<br />
3. Drag in to your design Comment Data Set.<br />
4. Drag in to your design the parameters pShowEdit and pShowComment. These are used to hide the comments and editor when it is no longer used.<br />
5. Drag in to your design the SubmitForm Text item to the top of your report. This needs to be done only once per report. If your report has additional parameters add their names to the user property parameterList (comma delimited). This will ensure that the same parameters that were used to execute the original report will be used in each additional execution.<br />
6. Drag the CommentGrid in to your report design. You can drag this grid as many times in to your report as needed (for example if there are different sections and each section has its own comments. You need to change the user property ‘userpropKey’ that is on the CommentGrid for each time you add the grid. This key is used to associate the comment you are entering to the specific section of the report. The comments are already filtered for the specific report you are using.