+ Start a Discussion
jaganjagan 

Bad Format of name while exporting the report

Hi  - I am getting a bad formant for account name and opportunity name while i am exporting the report in to excel. opportunity name is being reffered as "_HL_ENCODED_" + salesforce link to record + opportunity name + "_HL__blank_HL_". I could not find what is the issue here. can you please help ?

jaganjagan

FYI...they are the formula fields in custom object with Hyperlink function in the formula

Ashish_SFDCAshish_SFDC

Hi Jagan, 

 

The Formula fields are not values stored in records but the formula is calculated and displayed only upon Loadig of the Record's page. 

Hence when exported the formula is not calculated at the time of export but the value in the field is getting exported. 

The work around would only be writing the formula in excel again where ever possible. 

See the blog might help, http://simplysfdc.blogspot.sg/2013/06/salesforce-hyperlink-in-excel-file.html

Vote for the related Idea in the Exchange: https://success.salesforce.com/ideaView?id=08730000000GtcB 

 

Regards,

Ashish

If your question is Answered, please mark this post as solved.