There is a BIRT report which has 3 datasets and all the 3 data set has a field LOCATION. This field should have hyperlink to move from first dataset to second data set and then to third dataset. It is not necessary that all the 3 dataset would always have values. If all the 3 dataset has values then the hyperlink moves from First data set to second and then from second data set to third data set. However if there are only 2 dataset then the hyperlink does not move from first data set to second data set. Below is the current hyperlink and bookmark that I have used, Please let me know your thoughts.
**first dataset **
hyperlink - "LEV2~"+row["location"]
bookmark - "LEV1~"+row["location"]
table of contents -
**second dataset **
hyperlink - "LEV3~"+row["location"]
bookmark - "LEV2~"+row["location"]
table of contents -
**third dataset **
hyperlink - "LEV2~"+row["location"]
bookmark - "LEV3~"+row["location"]
table of contents -
