BI Publisher export report to excel with hyperlinks
Hi,
I created a report using RTF templates with dynamic drill down links using {$CURRENT_SERVER_URL}.
At run time the drill down works just fine.
when I export the report as PDF, the drill down also works fine, only the user is asked to login again which is normal if the session is not active on the same browser.
My issue is with excel export, the hyperlink is not saved properly, I lose the server,excel replaces the correct server path with my local machine path where the excel file was saved.
Is there a way to keep the drill down links intact, the same way as the pdf keeps them.