Linking data on Birt report to JSP page

alex09

I have a birt report that has the following simplified structure:

Month/Year | Atrribute 1 | Attribute 2 |

---

1/2008 | 5 | 2
2/2008 | 3 | 6

etc


The numbers in each cell represent the "count" of records satisfying some "SQL" condition in the month/year specified in the first column.

I want to make the data on my report as HTML links such that when the user clicks on a number, it will (fetch the corresponding records from the DB), revert to a JSP page and view these records.

I think I have to do this using Javascript to find the row/column selected, but how can I embed the Javascript in the rptdesign so that it will be embedded in the generated HTML page? Also, if you have any comments or remarks, please let me know.

I truly appreciate your input.

cypherdj

Simply select the table/crosstab data cell you wish to be clickable.

In the property editor, select Hyperlink.

Select URI and click the expression editor to build your hyperlink according to the info available (row["ABC"] will get the field value for your field).

Hope that helps,
Cedric