Hyperlink to a Internal Bookmark between two tables doesn't work

I am using BIRT 2.6.2.

I am trying to link a data column from one table to a data column in another table using a internal book mark.

Attached is my report design file. I am not being able to link the two columns. Can some one look at it figure out what the problem is.

Thanks in advance for your help!!!

Find more posts tagged with

Comments

mwilliams

You don't have access to row["Column Binding 1"] in the first table, so the expression won't work. Table1 doesn't know what this is. You need to think about the result of the expression. That is what the bookmarks are, the actual date, not the row["Column Binding 1"] text. So, try using row["BUSINESS_DATE"] as the Linked expression for the hyperlink rather than choosing the bookmark expression that you put in to define the bookmarks. That should do it. Let me know.

kumarisam

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="80271" data-time="1311111438" data-date="19 July 2011 - 02:37 PM"><p>
You don't have access to row["Column Binding 1"] in the first table, so the expression won't work. Table1 doesn't know what this is. You need to think about the result of the expression. That is what the bookmarks are, the actual date, not the row["Column Binding 1"] text. So, try using row["BUSINESS_DATE"] as the Linked expression for the hyperlink rather than choosing the bookmark expression that you put in to define the bookmarks. That should do it. Let me know.<br /></p></blockquote>

kumarisam

I changed the report design to use a same data set for both tables and used expressions like you mentioned.
But still it does not work.
Attached is the changed report design file.

mwilliams

Can you recreate the issue with the sample database so I can run the report? Thanks!

kumarisam

I have attached the spreadsheet of the report for you to look at in Excel. May be that will give you some clue. I will setup the sample database and work on send you something similar to what I am trying to do.
thanks for your help!!!!

mwilliams

Does it work when not exporting to XLS? Maybe the XLS output is the problem.