How to Navigate in same excelsheet report tabs using hyperlink
I have requirement in that we have to link same excelsheet data from different tabs using hyperlink.
For example. In excelsheet I am using two tables to display data i.e Customer Table and Order Table.
On first sheet I am displaying CustomerData and in remaining sheets I am displaying Customer Order details.
I have attached sample report.
So when you click CustomerNumber from first sheet (ex. 114) then user should be navigated to tab 114.
How can we achieve this in BIRT. I am using BIRT 4.5.0 version.
Please let me know if anyone knows anything about this.
Thanks in advance.