{"id":24305,"date":"2021-12-30T10:25:32","date_gmt":"2021-12-30T10:25:32","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagex3\/?p=24305"},"modified":"2021-12-30T10:28:39","modified_gmt":"2021-12-30T10:28:39","slug":"special-fields-in-crystal-report-prints-in-different-language","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagex3\/2021\/12\/30\/special-fields-in-crystal-report-prints-in-different-language\/","title":{"rendered":"Special Fields in Crystal Report prints in different language"},"content":{"rendered":"\n

In the Sage X3<\/a>, you have various standard reports for almost every screen which are developed in Crystal Report. Also you can develop your own crystal report as per client need. After printing report, the content in the report gets printed depending on the language setup done in the Sage X3 for the login user. But you might have notice that irrespective of the language setup done in Sage X3 application, there are Crystal \u2018Special fields\u2018 which behaves differently.<\/p>\n\n\n\n

In simple words, Crystal Report prints all the formulas and database fields as per the language setting done in Sage X3 folder for logged in user but Crystal reports \u201cSpecial fields\u201c like \u2018Page Number\u2018, \u2018Print date\u2018 etc. Prints as per the Windows server region setup\/language setup done on the server.<\/p>\n\n\n\n

Recently we came across a situation where we wanted to develop Crystal report for one of the client which is based in India and server is hosted in Spain . So the Sage X3 language setup done in English language for India Users but windows application server is login with Spanish Language. In Crystal report, we want to use Special field “Page N of M” so that it will print page number at the page footer section. But whenever we prints the report, reports gets print in English language except for that special field \u2018Page N of M\u2018 which gets print in Spanish as “P\u00e1gina 1 de 1” instead of “Page 1 of 1” in the English.<\/p>\n\n\n\n

New Stuff: <\/strong>Enable Comment section for specific transaction type in sales invoice screen<\/a><\/p>\n\n\n\n

\"\"<\/a><\/center>\n
“Page N of M” in the Spanish language<\/center><\/font>\n\n\n\n

So we search on various forums and found that SAP Crystal standard dll behaves in that fassion only and we do not have control over it. So to overcome that situation, we build the formula that will print page number in English language.<\/p>\n\n\n\n

Please see the below steps:<\/p>\n\n\n\n

Step 1:<\/strong> Create a formula in the crystal report as “page_no”<\/p>\n\n\n\n

\"Formula<\/a><\/center>\n
Formula name<\/center><\/font>\n\n\n\n

Step 2:<\/strong> After creating formula add below lines of code in that formula.<\/p>\n\n\n\n

\"Formula\"<\/a><\/center>\n
Formula<\/center><\/font>\n\n\n\n

Step 3:<\/strong> After creating the formula, place the formula in footer section of the report.<\/p>\n\n\n\n

Step 4:<\/strong> Save the report and then print .<\/p>\n\n\n\n

Please refer below screen shot. <\/p>\n\n\n\n

\"\"<\/a><\/center>\n
“Page N of the M” in the English language<\/center><\/font>\n\n\n\n

You have noticed the report gets printed in English language even if the windows server setup is done in Spanish language as it takes the Sage X3 language setup done on that folder for the India User. <\/p>\n\n\n\n

In this way, you can display “Page N of M” in the English or any other required language irrespective of the client’s server regional language.<\/p>\n\n\n\n

About Us<\/strong><\/h2>\n\n\n\n

Greytrix \u2013 a globally recognized and one of the oldest Sage Development Partners is a one-stop solution provider for Sage ERP and Sage CRM organizational needs. Being acknowledged and rewarded for multi-man years of experience and expertise, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third-party add-on development, and implementation competence.<\/p>\n\n\n\n

Greytrix has some unique integration solutions developed for Sage CRM<\/a> with Sage ERPs namely Sage X3<\/a>, Sage Intacct<\/a>, Sage 100<\/a>, Sage 500<\/a>, and Sage 300<\/a>. We also offer best-in-class Sage ERP and Sage CRM customization and development services to Business Partners, End Users, and Sage PSG worldwide. Greytrix helps in the migration of Sage CRM from Salesforce | ACT! | SalesLogix | Goldmine | Sugar CRM | Maximizer. Our Sage CRM Product Suite includes addons like  Greytrix Business Manager, Sage CRM Project Manager, Sage CRM Resource Planner, Sage CRM Contract Manager, Sage CRM Event Manager, Sage CRM Budget Planner, Gmail Integration, Sage CRM Mobile Service Signature, Sage CRM CTI Framework.<\/p>\n\n\n\n

Greytrix is a recognized Sage Champion Partner for GUMU™ Sage X3 \u2013 Sage CRM integration listed on Sage Marketplace<\/a> and Sage CRM \u2013 Sage Intacct integration listed on Sage Intacct Marketplace<\/a>. The GUMU™ Cloud framework<\/a> by Greytrix forms the backbone of cloud integrations that are managed in real-time for the processing and execution of application programs at the click of a button.<\/p>\n\n\n\n

For more information on our integration solutions, please contact us at sage@greytrix.com<\/a>. We will be glad to assist you.<\/p>\n","protected":false},"excerpt":{"rendered":"

In the Sage X3, you have various standard reports for almost every screen which are developed in Crystal Report. Also you can develop your own crystal report as per client need. After printing report, the content in the report gets printed depending on the language setup done in the Sage X3 for the login user.\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13,8],"tags":[461,3516,3517,3514,3515,3518],"class_list":["post-24305","post","type-post","status-publish","format-standard","hentry","category-integration","category-sage-erp-x3","tag-crystal-report","tag-different-language","tag-formula","tag-page-n-of-m","tag-page-no","tag-special-fields"],"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/24305","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/comments?post=24305"}],"version-history":[{"count":19,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/24305\/revisions"}],"predecessor-version":[{"id":24343,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/posts\/24305\/revisions\/24343"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/media?parent=24305"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/categories?post=24305"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagex3\/wp-json\/wp\/v2\/tags?post=24305"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}