Sage 100

 View Only
  • 1.  Chine language in Crystal Reports

    Posted 10-25-2024 19:52

    I am trying to display item description on the invoice form in Sage 100 in English and in Chinese. Has anyone had experience and success in doing this?

    I tried adding the Chinese language pack in windows settings but that didn't help. I need to add another setting in crystal reports which I don't think the Sage version of Crystal reports has.

    I have found through searching Google that Millet Software Cut Light has a translation feature - I am going to try this. 

    Looking forward to hearing if anyone has been able to achieve Chinese text in crystal reports.

    Thanks.



    ------------------------------
    Robin Saacks
    Timac Business Systems
    (310) 571-1200 x21
    www.timacinc.com
    ------------------------------


  • 2.  RE: Chine language in Crystal Reports

    Posted 10-26-2024 10:17

    I am most definitely not an expert in language translation. It doesn't seem as if the Chinese language is a 1:1 translation letter for letter to the english language. I'm not sure how this type of translation would be accomplished without either a UDF to hold the Chinese equivalent description/name or a third-party.



    ------------------------------
    Wayne Schulz
    wayne@s-consult.com
    Schulz Consulting
    (860) 516-8990
    CT
    ------------------------------



  • 3.  RE: Chine language in Crystal Reports

    Posted 10-28-2024 14:34

    We have a client that does this, but the Chinese Description is stored and updated in and Access Database completely independent from Sage 100. 

    Basically, the Access Database has a table that holds the item Code and the Unicode Characters of the Chinese description in second field. Then we just link the Crystal form code to the Access table with a left outer join based on item code.  

    We did not create the Access Database table, the client did that on their own, so I'm not much help there, but we did link the crystal and put the fields on the Sage 100 form code. (I think it is either a picking sheet or a purchase order form). 



    ------------------------------
    David Overholt
    DWD Technology Group
    ------------------------------



  • 4.  RE: Chine language in Crystal Reports

    Posted 10-28-2024 19:47
    Thanks David. That is very good to know. If you were able to get it to work through access, we can likely get it to work through SQL.

    Robin Saacks | Operations
    TIMAC BUSINESS SYSTEMS
    T (310) 571-1200 x21
    C (310) 709-1358





  • 5.  RE: Chine language in Crystal Reports

    Posted 10-29-2024 06:39

    I'm sure you can! In fact, we suggested that the client upgrade to Sage 100 Premium on the next upgrade



    ------------------------------
    David Overholt
    DWD Technology Group
    ------------------------------



  • 6.  RE: Chine language in Crystal Reports

    Posted 10-29-2024 14:58

    I go SQL working to allow Chinese. I set the field attribute colllation to Simplified Chines. Now I just need to try render it in Crystal. Should work.



    ------------------------------
    Robin Saacks
    Timac Business Systems
    (310) 571-1200 x21
    www.timacinc.com
    ------------------------------