Report Saved to Excel = Links don't work

Troubles_In_Paradise

Hi guys I searched the forum for this but I couldn't find what I need.
I'm wondering if someone has already faced this problem.
To create a link between our custom report to the customer card I followed this guide:
http://msdn.microsoft.com/en-us/library/dd301304.aspx
And it works :thumbsup:.
The problem is that if I save the report in excel links don't work anymore: the system said me "You have to specify the Service Name and the Company Name".
In fact links are "saved in excel" in a wrong way, 2 "/" are missing (as you can see from the attachment):

The strange thingh is that if I save the report in PDF links work like a charm.

Is this a know issue?

Nav 2009 R2 W1
Microsoft Office 2010

Many thx in advance!

Troubles_In_Paradise

For now the only solution I found is to create in Nav the link in a string variable, and then use this variable as value of property Jump to URL of the textbox needed in VS.
Very important is to create the link specifing the Server Name and the Company Name in order to make the links work also in excel and (for some reasons excel doesn't like "////").

Many thx to Belias that gave this hint.

vigneshbose

This issue is bcos of the escape characters in Excel.... you can find that the '?' and the '&' are changed to '/' in the excel format, to avoide this you have to added add '/' before each special character as text formate then convet it to Hyperlink.