Hyperlinking problem

[genox]

Hi All,

I want to use a hyperlink so I can drill-down from a summary to a detail report.

Having changed the controls' LinkExp property, the hyperlink is created but when it tries to open the second report the error message "Unable to open report instance" is displayed.

This is the link I'm using

"contractordetail.roi#DetailFrame::COMPANIESNAMEControl=""" & [NAME] & """"

contractordetail.roi is stored in the same folder as the summary report.

Can anyone tell me where I am going wrong here?

Thanks in advance

 

[gdwood]

Not sure exactly what your trying to do, and how you are doing it, but we do this a lot in our reports. We use the buildfromrow method of the field that we want to user to click on and then builf the link with the parameters that we need to pass ie:

Me.LinkTo = "\<folder>\<reportname>.Rox?AcctNum=" & row.GetValue("SRC_ACCT")

Me.LinkTo = Me.LinkTo & "&Sbu_Code=" & Sbu_Code

Me.LinkTo = Me.LinkTo & "&enddate=" & enddate

where we pass the account sbu and end date. hope this helps but i'm not sure if this is the same situation