{"id":10793,"date":"2015-08-21T11:27:15","date_gmt":"2015-08-21T11:27:15","guid":{"rendered":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/?p=10793"},"modified":"2015-08-21T11:27:15","modified_gmt":"2015-08-21T11:27:15","slug":"error-exporting-reports-to-excel-in-crm-part-4","status":"publish","type":"post","link":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/08\/21\/error-exporting-reports-to-excel-in-crm-part-4\/","title":{"rendered":"Error exporting reports to excel in CRM part 4"},"content":{"rendered":"

As you know we have been writing blogs on issues being faced while extracting reports data in excel and issues related to Dashboards not working. You can go through the links added below for your reference.
\nRelated Stuff:<\/strong><\/em><\/span> Error exporting reports to excel in CRM part 3<\/a>
\nEven in today\u2019s blog, we will be discussing issue related to tomcat service which was running perfectly but users were not able to use Dashboards and Export to excel functionality.
\nTo check the occurrence of this issue, we have gone through the various forums and blogs written on this particular topic. But, found the configuration which was supposed to be available under JDBC<\/strong> file was correct.
\nBelow is the SQL Server configuration available under JDBC file.
\n\"IMG1\"<\/a>
\nAfter some trial and error method, I just made a small change in the file by removing the Server instance<\/strong> and then restarted the tomcat service and everything started working smoothly. Below is the modified file for your reference.
\n\"IMG2\"<\/a>
\nHere, in this file instead of mentioning Server name we can enter IP address of the server followed by same configuration..
\nHope this helps!
\nAlso Read:<\/strong><\/em><\/span>
\n1) Restricting Reports data to authorized users<\/a>
\n2) Apache Tomcat Java configuration issues<\/a>
\n3) Error exporting reports to excel in CRM part 2<\/a>
\n4) Error exporting reports to excel in CRM<\/a>
\n5) Error Opening PDF files in Internet Explorer 9<\/a>
\n <\/p>\n","protected":false},"excerpt":{"rendered":"

As you know we have been writing blogs on issues being faced while extracting reports data in excel and issues related to Dashboards not working. You can go through the links added below for your reference. Related Stuff: Error exporting reports to excel in CRM part 3 Even in today\u2019s blog, we will be discussing\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":[73,83,99,102,138,145,146,193,317,332,336,337,342,1],"tags":[793,907,921,1091,1107,1121,1474,1920],"class_list":["post-10793","post","type-post","status-publish","format-standard","hentry","category-configuration","category-crm72","category-dashboard-sage-crm","category-database-sage-crm","category-error","category-export","category-export-to-excel","category-interactive-dashboard-sage-crm","category-report","category-sage-crm","category-sage-crm-7-1-sp2","category-sage-crm-7-2","category-sage-crm7-3","category-uncategorized","tag-crm","tag-dashboard","tag-database","tag-error","tag-excel","tag-exporting","tag-jdbc","tag-report"],"yoast_head":"\nError exporting reports to excel in CRM part 4 - 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\/2015\/08\/21\/error-exporting-reports-to-excel-in-crm-part-4\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Error exporting reports to excel in CRM part 4 - Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"og:description\" content=\"As you know we have been writing blogs on issues being faced while extracting reports data in excel and issues related to Dashboards not working. You can go through the links added below for your reference. Related Stuff: Error exporting reports to excel in CRM part 3 Even in today\u2019s blog, we will be discussing\u2026 Read More »\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/08\/21\/error-exporting-reports-to-excel-in-crm-part-4\/\" \/>\n<meta property=\"og:site_name\" content=\"Sage CRM \u2013 Tips, Tricks and Components\" \/>\n<meta property=\"article:published_time\" content=\"2015-08-21T11:27:15+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2015\/08\/IMG13.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\/2015\/08\/21\/error-exporting-reports-to-excel-in-crm-part-4\/\",\"url\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/08\/21\/error-exporting-reports-to-excel-in-crm-part-4\/\",\"name\":\"Error exporting reports to excel in CRM part 4 - Sage CRM \u2013 Tips, Tricks and Components\",\"isPartOf\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/08\/21\/error-exporting-reports-to-excel-in-crm-part-4\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/08\/21\/error-exporting-reports-to-excel-in-crm-part-4\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2015\/08\/IMG13.jpg\",\"datePublished\":\"2015-08-21T11:27:15+00:00\",\"author\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/08\/21\/error-exporting-reports-to-excel-in-crm-part-4\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/08\/21\/error-exporting-reports-to-excel-in-crm-part-4\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/08\/21\/error-exporting-reports-to-excel-in-crm-part-4\/#primaryimage\",\"url\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2015\/08\/IMG13.jpg\",\"contentUrl\":\"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2015\/08\/IMG13.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/08\/21\/error-exporting-reports-to-excel-in-crm-part-4\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.greytrix.com\/blogs\/sagecrm\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Error exporting reports to excel in CRM part 4\"}]},{\"@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":"Error exporting reports to excel in CRM part 4 - 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\/2015\/08\/21\/error-exporting-reports-to-excel-in-crm-part-4\/","og_locale":"en_US","og_type":"article","og_title":"Error exporting reports to excel in CRM part 4 - Sage CRM \u2013 Tips, Tricks and Components","og_description":"As you know we have been writing blogs on issues being faced while extracting reports data in excel and issues related to Dashboards not working. You can go through the links added below for your reference. Related Stuff: Error exporting reports to excel in CRM part 3 Even in today\u2019s blog, we will be discussing\u2026 Read More »","og_url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/08\/21\/error-exporting-reports-to-excel-in-crm-part-4\/","og_site_name":"Sage CRM \u2013 Tips, Tricks and Components","article_published_time":"2015-08-21T11:27:15+00:00","og_image":[{"url":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2015\/08\/IMG13.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\/2015\/08\/21\/error-exporting-reports-to-excel-in-crm-part-4\/","url":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/08\/21\/error-exporting-reports-to-excel-in-crm-part-4\/","name":"Error exporting reports to excel in CRM part 4 - Sage CRM \u2013 Tips, Tricks and Components","isPartOf":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/08\/21\/error-exporting-reports-to-excel-in-crm-part-4\/#primaryimage"},"image":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/08\/21\/error-exporting-reports-to-excel-in-crm-part-4\/#primaryimage"},"thumbnailUrl":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2015\/08\/IMG13.jpg","datePublished":"2015-08-21T11:27:15+00:00","author":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/#\/schema\/person\/e7ff1c8f4763b47730d6bc5e74d59c1f"},"breadcrumb":{"@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/08\/21\/error-exporting-reports-to-excel-in-crm-part-4\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/08\/21\/error-exporting-reports-to-excel-in-crm-part-4\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/08\/21\/error-exporting-reports-to-excel-in-crm-part-4\/#primaryimage","url":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2015\/08\/IMG13.jpg","contentUrl":"http:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-content\/uploads\/2015\/08\/IMG13.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/2015\/08\/21\/error-exporting-reports-to-excel-in-crm-part-4\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/"},{"@type":"ListItem","position":2,"name":"Error exporting reports to excel in CRM part 4"}]},{"@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\/10793","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=10793"}],"version-history":[{"count":0,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/posts\/10793\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/media?parent=10793"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/categories?post=10793"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.greytrix.com\/blogs\/sagecrm\/wp-json\/wp\/v2\/tags?post=10793"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}