{"id":3038,"date":"2012-11-14T14:13:08","date_gmt":"2012-11-14T14:13:08","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/?p=3038"},"modified":"2012-11-14T14:13:08","modified_gmt":"2012-11-14T14:13:08","slug":"generating-a-simple-pie-chart-in-sage-crm-using-com-api","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/11\/14\/generating-a-simple-pie-chart-in-sage-crm-using-com-api\/","title":{"rendered":"Generating a Simple Pie chart in Sage CRM using COM API"},"content":{"rendered":"

As we all know, Pie Chart is a special chart that uses “pie slices” to show relative sizes of data. Pie charts can be used in Sage CRM for a graphical representation of data. They are directly inherited from Graphics and are an extension of the Graphic Block.
\nHere if we wish to see a graphical representation of data for a particular entity, we can develop a custom page and use the same to display information in graphics.
\nBelow is the example of adding the same for the Company entity.
\nCRM connects to the Company table and obtains the information. To create a chart for Company entity, you need to follow the below steps.<\/p>\n

    \n
  1. Create a new tab named PieCharts<\/strong> under My CRM, that links to a custom page<\/strong>.<\/li>\n
  2. Create the custom asp page to display the chart.<\/li>\n
  3. Below is the code to be added to the asp file.<\/li>\n<\/ol>\n

     
    \n<!– #include file =”sagecrm.js” –><\/em>
    \n<%<\/em>
    \nvar sContainer=CRM.GetBlock(“container”);<\/em>
    \nvar strSQL = “select count(comp_companyid) as ‘mycount’, ‘Class 1000’ as ‘mytype’ from Company where comp_deleted=0 union select count(comp_companyid) as ‘mycount’, ‘Class 3000’ as ‘mytype’ from Company where comp_deleted=1 union select count(comp_companyid) as ‘mycount’, ‘With no class’ as ‘mytype’ from Company where comp_deleted is null”;<\/em>
    \n\u00a0<\/em>
    \nvar myBlock=CRM.GetBlock(“chart”);<\/em>
    \nwith(myBlock)<\/em>
    \n{<\/em>
    \nStylename(“Pie”); <\/em>
    \nxlprop=”mytype”;<\/em>
    \nyprop=”mycount”;<\/em>
    \nSQLText= strSQL;<\/em>
    \nImageWidth=950;<\/em>
    \n}<\/em>
    \n\u00a0<\/em>
    \nsContainer.AddBlock(myBlock)<\/em>
    \nResponse.Write(sContainer.Execute());<\/em>
    \n%><\/em>
    \nTo view the results, select My CRM and click on PieChart<\/strong> tab to see below output.
    \n\"\"<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

    As we all know, Pie Chart is a special chart that uses “pie slices” to show relative sizes of data. Pie charts can be used in Sage CRM for a graphical representation of data. They are directly inherited from Graphics and are an extension of the Graphic Block. Here if we wish to see a\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[54,332],"tags":[],"class_list":["post-3038","post","type-post","status-publish","format-standard","hentry","category-chart-sage-crm","category-sage-crm"],"yoast_head":"\nGenerating a Simple Pie chart in Sage CRM using COM API - 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\/2012\/11\/14\/generating-a-simple-pie-chart-in-sage-crm-using-com-api\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Generating a Simple Pie chart in Sage CRM using COM API - Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"As we all know, Pie Chart is a special chart that uses “pie slices” to show relative sizes of data. Pie charts can be used in Sage CRM for a graphical representation of data. They are directly inherited from Graphics and are an extension of the Graphic Block. Here if we wish to see a\u2026 Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/11\/14\/generating-a-simple-pie-chart-in-sage-crm-using-com-api\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2012-11-14T14:13:08+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2012\/11\/chart1.png\" \/>\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\/2012\/11\/14\/generating-a-simple-pie-chart-in-sage-crm-using-com-api\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/11\/14\/generating-a-simple-pie-chart-in-sage-crm-using-com-api\/\",\"name\":\"Generating a Simple Pie chart in Sage CRM using COM API - Sage CRM \u2013 Tips, Tricks and Components\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/11\/14\/generating-a-simple-pie-chart-in-sage-crm-using-com-api\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/11\/14\/generating-a-simple-pie-chart-in-sage-crm-using-com-api\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2012\/11\/chart1.png\",\"datePublished\":\"2012-11-14T14:13:08+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/11\/14\/generating-a-simple-pie-chart-in-sage-crm-using-com-api\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/11\/14\/generating-a-simple-pie-chart-in-sage-crm-using-com-api\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/11\/14\/generating-a-simple-pie-chart-in-sage-crm-using-com-api\/#primaryimage\",\"url\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2012\/11\/chart1.png\",\"contentUrl\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2012\/11\/chart1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/11\/14\/generating-a-simple-pie-chart-in-sage-crm-using-com-api\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Generating a Simple Pie chart in Sage CRM using COM API\"}]},{\"@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":"Generating a Simple Pie chart in Sage CRM using COM API - 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\/2012\/11\/14\/generating-a-simple-pie-chart-in-sage-crm-using-com-api\/","og_locale":"en_US","og_type":"article","og_title":"Generating a Simple Pie chart in Sage CRM using COM API - Sage CRM \u2013 Tips, Tricks and Components","og_description":"As we all know, Pie Chart is a special chart that uses “pie slices” to show relative sizes of data. Pie charts can be used in Sage CRM for a graphical representation of data. They are directly inherited from Graphics and are an extension of the Graphic Block. Here if we wish to see a\u2026 Read More »","og_url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/11\/14\/generating-a-simple-pie-chart-in-sage-crm-using-com-api\/","og_site_name":"Sage CRM \u2013 Tips, Tricks and Components","article_published_time":"2012-11-14T14:13:08+00:00","og_image":[{"url":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2012\/11\/chart1.png","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\/2012\/11\/14\/generating-a-simple-pie-chart-in-sage-crm-using-com-api\/","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/11\/14\/generating-a-simple-pie-chart-in-sage-crm-using-com-api\/","name":"Generating a Simple Pie chart in Sage CRM using COM API - Sage CRM \u2013 Tips, Tricks and Components","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/11\/14\/generating-a-simple-pie-chart-in-sage-crm-using-com-api\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/11\/14\/generating-a-simple-pie-chart-in-sage-crm-using-com-api\/#primaryimage"},"thumbnailUrl":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2012\/11\/chart1.png","datePublished":"2012-11-14T14:13:08+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/11\/14\/generating-a-simple-pie-chart-in-sage-crm-using-com-api\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/11\/14\/generating-a-simple-pie-chart-in-sage-crm-using-com-api\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/11\/14\/generating-a-simple-pie-chart-in-sage-crm-using-com-api\/#primaryimage","url":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2012\/11\/chart1.png","contentUrl":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2012\/11\/chart1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2012\/11\/14\/generating-a-simple-pie-chart-in-sage-crm-using-com-api\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/"},{"@type":"ListItem","position":2,"name":"Generating a Simple Pie chart in Sage CRM using COM API"}]},{"@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\/3038","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=3038"}],"version-history":[{"count":0,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/3038\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/media?parent=3038"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/categories?post=3038"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/tags?post=3038"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}