Im trying to get the hyperlink functionality to work wherby i can use a hyperlink to link to another part of my report, almost like a master/detail report with a listing at the beginning with the ability to hyperlink to the relevant detail breakdown futher down the report.
I have a Field called F_company1 with source company_num and another field called F_company2 with source company_num (both from same data source)
i wish to be able to click on the F_company1 field and be brougt to the corresponding F_company2 field
I have set up the hyperlink settings under properties for F_company1 with #'COMPANY_NUM_' || LTRIM(TOCHAR(:COMPANY_NUM)) and the hyperlink destination settings under properties for F_company2 with 'COMPANY_NUM_' || LTRIM(TOCHAR(:COMPANY_NUM)) so that they should dynamically match and therfore link?
however what i am finding is that when i click on the hyperlink field in the PDF it brings me to the end of the report and not to the corresponding comapny number , am i missing something or indeed doing something wrong in this approach