{"id":9253,"date":"2014-12-10T09:46:20","date_gmt":"2014-12-10T09:46:20","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/?p=9253"},"modified":"2014-12-10T09:46:20","modified_gmt":"2014-12-10T09:46:20","slug":"display-data-in-graphical-form-in-sage-crm","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/12\/10\/display-data-in-graphical-form-in-sage-crm\/","title":{"rendered":"Display data in Graphical form in Sage CRM"},"content":{"rendered":"

Sage CRM is an user friendly crm solution in which one can customize the way they want to extract data for analysis and reporting. In this blog post, we will explain how to use Sage CRM Graphic objects to show data in Graphical mode.<\/p>\n

GUMU Sage CRM integration for Sage 100 ERP<\/span><\/strong>
\n<\/em>Get real-time insights of your Sage 100 Sales\/Customer\/item data using the new GUMU Dashboard in Sage CRM<\/a><\/p>\n

Consider an example where you want to show Forecast Data <\/strong>in Graphical form. You need to follow below steps for the same.
\n1) Login to Sage CRM and Navigate to below path.
\nAdministration | Customization | Opportunity Progress
\n2) Select the Screens<\/strong> tab and click on the Opportunity Status<\/strong> Box.
\n3) Select Forecast (oppo_forecast) field and paste the below script in the Create Script<\/strong> section.
\nvar strForecast=CRM.GetContextInfo(‘opportunity’,’oppo_forecast’);
\nvar graphic;
\ngraphic=CRM.GetBlock(‘graphic’);
\ngraphic.DisplayForm = false;
\ngraphic.Border=1;
\ngraphic.ImageWidth=20;
\ngraphic.ImageHeight=20;
\ngraphic.Animation(‘Add’,’1′);
\ngraphic.ImageWidth= strForecast\/5;
\ngraphic.ImageHeight=20;
\ngraphic.GradientFill(‘Green’,’ Green ‘,’LeftToRight’);
\ngraphic.TextOut(40, 1, strForecast, true);
\ngraphic.Animation(‘Add’,’100′);
\nCaption = CRM.GetTrans (“colnames\u201d, oppo_forecast”) +”:”+graphic.Execute();
\nCaptionPos = 2;
\n4) Click on Update button and finally click on Save button to save changes.
\nNow when you navigate to Opportunity Summary screen, you will observe that Forecast field is visible in a Graphic format as shown below.
\n\"G1\"<\/a>
\nYou can apply this trick to any other field with a few changes.
\nAlso Read:<\/span>
\n<\/em><\/strong>1) Generating a Simple Pie chart in Sage CRM using COM API<\/a>
\n2)\u00a0Increase number of width columns for Screen block
\n<\/a>3) Information and Error Message feature in Sage CRM v7.2<\/a>
\n4) Avoid scrolling with Collapse Screen Feature in Sage CRM7.2<\/a>
\n5)\u00a0Manage the size of the Recent List<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Sage CRM is an user friendly crm solution in which one can customize the way they want to extract data for analysis and reporting. In this blog post, we will explain how to use Sage CRM Graphic objects to show data in Graphical mode. GUMU Sage CRM integration for Sage 100 ERP Get real-time insights\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[83,162,168,329,332,336,337,342],"tags":[833,1175,1203,1204,2010,2030,2031,2033],"class_list":["post-9253","post","type-post","status-publish","format-standard","hentry","category-crm72","category-form","category-graph-sage-crm","category-sage-300-erp-2012","category-sage-crm","category-sage-crm-7-1-sp2","category-sage-crm-7-2","category-sage-crm7-3","tag-crm7-0","tag-form","tag-graph","tag-graphical","tag-sage-crm","tag-sage-crm-7-0","tag-sage-crm-7-1","tag-sage-crm-7-2"],"yoast_head":"\nDisplay data in Graphical form in Sage CRM - Sage CRM \u2013 Tips, Tricks and Components<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/12\/10\/display-data-in-graphical-form-in-sage-crm\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Display data in Graphical form in Sage CRM - Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"Sage CRM is an user friendly crm solution in which one can customize the way they want to extract data for analysis and reporting. In this blog post, we will explain how to use Sage CRM Graphic objects to show data in Graphical mode. GUMU Sage CRM integration for Sage 100 ERP Get real-time insights\u2026 Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/12\/10\/display-data-in-graphical-form-in-sage-crm\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2014-12-10T09:46:20+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2014\/12\/G11-1024x455.jpg\" \/>\n<meta name=\"author\" content=\"greysagecrm\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"greysagecrm\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/12\/10\/display-data-in-graphical-form-in-sage-crm\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/12\/10\/display-data-in-graphical-form-in-sage-crm\/\",\"name\":\"Display data in Graphical form in Sage CRM - Sage CRM \u2013 Tips, Tricks and Components\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/12\/10\/display-data-in-graphical-form-in-sage-crm\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/12\/10\/display-data-in-graphical-form-in-sage-crm\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2014\/12\/G11-1024x455.jpg\",\"datePublished\":\"2014-12-10T09:46:20+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/12\/10\/display-data-in-graphical-form-in-sage-crm\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/12\/10\/display-data-in-graphical-form-in-sage-crm\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/12\/10\/display-data-in-graphical-form-in-sage-crm\/#primaryimage\",\"url\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2014\/12\/G11-1024x455.jpg\",\"contentUrl\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2014\/12\/G11-1024x455.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/12\/10\/display-data-in-graphical-form-in-sage-crm\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Display data in Graphical form in Sage CRM\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\",\"name\":\"Sage CRM \u2013 Tips, Tricks and Components\",\"description\":\"Explore the possibilities with Sage CRM insights through our comprehensive blogs. As a leading Sage partner, Greytrix helps businesses maximize their Sage CRM potential with its rich expertise and immense knowledge. Here, you will find blogs that feature expert advice, tips & tricks, best practices, and comprehensive guides on customizing and configuring Sage CRM for your business. Stay informed with our regular updates and expert insights!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\",\"name\":\"greysagecrm\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g\",\"caption\":\"greysagecrm\"},\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/author\/greysagecrm\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Display data in Graphical form in Sage CRM - Sage CRM \u2013 Tips, Tricks and Components","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/12\/10\/display-data-in-graphical-form-in-sage-crm\/","og_locale":"en_US","og_type":"article","og_title":"Display data in Graphical form in Sage CRM - Sage CRM \u2013 Tips, Tricks and Components","og_description":"Sage CRM is an user friendly crm solution in which one can customize the way they want to extract data for analysis and reporting. In this blog post, we will explain how to use Sage CRM Graphic objects to show data in Graphical mode. GUMU Sage CRM integration for Sage 100 ERP Get real-time insights\u2026 Read More »","og_url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/12\/10\/display-data-in-graphical-form-in-sage-crm\/","og_site_name":"Sage CRM \u2013 Tips, Tricks and Components","article_published_time":"2014-12-10T09:46:20+00:00","og_image":[{"url":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2014\/12\/G11-1024x455.jpg","type":"","width":"","height":""}],"author":"greysagecrm","twitter_card":"summary_large_image","twitter_misc":{"Written by":"greysagecrm","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/12\/10\/display-data-in-graphical-form-in-sage-crm\/","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/12\/10\/display-data-in-graphical-form-in-sage-crm\/","name":"Display data in Graphical form in Sage CRM - Sage CRM \u2013 Tips, Tricks and Components","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/12\/10\/display-data-in-graphical-form-in-sage-crm\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/12\/10\/display-data-in-graphical-form-in-sage-crm\/#primaryimage"},"thumbnailUrl":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2014\/12\/G11-1024x455.jpg","datePublished":"2014-12-10T09:46:20+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/12\/10\/display-data-in-graphical-form-in-sage-crm\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/12\/10\/display-data-in-graphical-form-in-sage-crm\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/12\/10\/display-data-in-graphical-form-in-sage-crm\/#primaryimage","url":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2014\/12\/G11-1024x455.jpg","contentUrl":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2014\/12\/G11-1024x455.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2014\/12\/10\/display-data-in-graphical-form-in-sage-crm\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/"},{"@type":"ListItem","position":2,"name":"Display data in Graphical form in Sage CRM"}]},{"@type":"WebSite","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/","name":"Sage CRM \u2013 Tips, Tricks and Components","description":"Explore the possibilities with Sage CRM insights through our comprehensive blogs. As a leading Sage partner, Greytrix helps businesses maximize their Sage CRM potential with its rich expertise and immense knowledge. Here, you will find blogs that feature expert advice, tips & tricks, best practices, and comprehensive guides on customizing and configuring Sage CRM for your business. Stay informed with our regular updates and expert insights!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f","name":"greysagecrm","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c3b4325cb326e36467f945b9b9adf2bb85e907fe092d42eb36b39743b492e626?s=96&d=mm&r=g","caption":"greysagecrm"},"url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/author\/greysagecrm\/"}]}},"_links":{"self":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/9253","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/comments?post=9253"}],"version-history":[{"count":0,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/9253\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/media?parent=9253"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/categories?post=9253"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/tags?post=9253"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}