Sign in
Microsoft.com
 
Microsoft
 
 
 
Microsoft >
> 
> 
> 
CRM 2011 report contains special character which causes problem with summing in Excel

Unanswered CRM 2011 report contains special character which causes problem with summing in Excel

  • Thursday, January 31, 2013 4:59 PM
     
     
    Sign In to Vote
    0

    When we produce a report in CRM 2011 the amount fields contain a non-printable special character which when exported into Excel 2010 prevents us from summing the column. According to Windows Character Map the special character is called a Left to Right Mark.

    How do you prevent CRM 2011 from inserting this character?

    Our customer is not interested in summing the column in the report.  They are also not interested in cleansing the column in Excel after the import.

     

All Replies

  • Thursday, January 31, 2013 6:21 PM
     
     
    Sign In to Vote
    0

    Hi,

    What entity are you running this report from? Can you provide a screenshot of what the report looks like?

    Thanks,

    Roshan

    Roshan http://www.magnetismsolutions.com

     
  • Thursday, January 31, 2013 7:16 PM
     
     
    Sign In to Vote
    0

    Thanks roscoNZ for your consideration of this matter.

    It is a custom entity (not out of the box).  I have tried to include images, but am receiving a message stating "Body text cannot contain images or links until we are able to verify your account".

    I will try later to attach the images.

    • Marked As Answer by RonBG_HarrisCo Friday, February 01, 2013 3:12 PM
    • Unmarked As Answer by RonBG_HarrisCo Friday, February 01, 2013 3:12 PM
    •  
     
  • Monday, February 04, 2013 3:45 PM
     
     
    Sign In to Vote
    0

    Let's see if I can now post images on this site.  With all the quirkiness that I've experienced since creating the account on Jan-31, my money is a continuation of rejection.