Hey all,
I've created a report that calculates several fields from a query in the DB. One of the fields sums about 20 other fields. I'd like to make a hyperlink to another report which shows the details of this calculation. I've found that MS support says that hyperlinks don't work directly in reports but that you can export to have the links work.
When I export to HTML the report opens fine in the browser but when I click my hyperlink I get a connection error in IE. The path that the hyperlink goes is F:\DataBase_Design\STPDbase - 4141.mdb#Report rCaacPicV2PPLSolo -- is valid. The format of the path was created automatically with the hyperlink tool.
Anyone know what I've done wrong? or can propose an alternate method that looks/acts like a hyperlink without the export process?
Thanks!
Chris
I've created a report that calculates several fields from a query in the DB. One of the fields sums about 20 other fields. I'd like to make a hyperlink to another report which shows the details of this calculation. I've found that MS support says that hyperlinks don't work directly in reports but that you can export to have the links work.
When I export to HTML the report opens fine in the browser but when I click my hyperlink I get a connection error in IE. The path that the hyperlink goes is F:\DataBase_Design\STPDbase - 4141.mdb#Report rCaacPicV2PPLSolo -- is valid. The format of the path was created automatically with the hyperlink tool.
Anyone know what I've done wrong? or can propose an alternate method that looks/acts like a hyperlink without the export process?
Thanks!
Chris
