{"id":3337,"date":"2019-03-25T17:43:49","date_gmt":"2019-03-25T20:43:49","guid":{"rendered":"http:\/\/xexeu.elipse.com.br\/pt\/kb63563-exporting-a-chart-report-when-e3chart-is-not-visualized-on-screen\/"},"modified":"2019-07-05T16:24:10","modified_gmt":"2019-07-05T19:24:10","slug":"kb63563-exporting-a-chart-report-when-e3chart-is-not-visualized-on-screen","status":"publish","type":"post","link":"https:\/\/kb.elipse.com.br\/en\/kb63563-exporting-a-chart-report-when-e3chart-is-not-visualized-on-screen\/","title":{"rendered":"KB-63563: Exporting a chart report when E3Chart is not visualized on screen."},"content":{"rendered":"<div align=\"justify\">\n<p>Many times, a chart report must be exported automatically, with no intervention from the operator. Therefore, the Report&#8217;s Chart object must be set up so that data is moved correctly, since E3Chart&#8217;s <i>CopyConfig<\/i> method won&#8217;t be used.<\/p>\n<p>To do so, follow these guidelines:<\/p>\n<p>1. Create a Report and insert an E3Chart in its PageHeader section.<\/p>\n<div align=\"center\"><img loading=\"lazy\" title=\"\" src=\"http:\/\/kb.elipse.com.br\/pt-br\/images\/ID5026\/Img1.png\" alt=\"\" width=\"500\" height=\"336\" align=\"Baseline\" border=\"0\" \/><\/div>\n<p>2. Then, access the properties of the newly created E3Chart and set up the Query to be used by historic pens. If you need to filter the Query, this is where it needs to be set up.<\/p>\n<div align=\"center\"><img loading=\"lazy\" title=\"\" src=\"http:\/\/kb.elipse.com.br\/pt-br\/images\/ID5026\/Img2.png\" alt=\"\" width=\"500\" height=\"498\" align=\"Baseline\" border=\"0\" \/><\/div>\n<p><b>NOTE<\/b>: Make sure you&#8217;re setting up the E3Chart&#8217;s Query, and not the report&#8217;s.<\/p>\n<p>3. Once the Query is done, create and set up historic pens for each of the selected fields.<\/p>\n<div align=\"center\"><img loading=\"lazy\" title=\"\" src=\"http:\/\/kb.elipse.com.br\/pt-br\/images\/ID5026\/Img3.png\" alt=\"\" width=\"429\" height=\"328\" align=\"Baseline\" border=\"0\" \/><\/div>\n<p>4. Finally, set up the horizontal axis scale to display a historic, to-be-defined time interval inside the application.<\/p>\n<div align=\"center\"><img loading=\"lazy\" title=\"\" src=\"http:\/\/kb.elipse.com.br\/pt-br\/images\/ID5026\/Img4.png\" alt=\"\" width=\"383\" height=\"539\" align=\"Baseline\" border=\"0\" \/><\/div>\n<p>5. Once the Chart is set up, open the scripts editor, select PageHeader object and <i>OnBeforePrint <\/i>event. In this event, set up the previously inserted E3Chart&#8217;s Query filter, run the Querry, load the result, and organize it on screen.<\/p>\n<p>Example:<\/p>\n<pre><span style=\"background-color: #ffffff;\"><span style=\"color: #0000ff; font-family: Courier New;\">Sub OnBeforePrint<\/span><\/span>\r\n\r\n<span style=\"font-family: Courier New;\"><span style=\"color: #0000ff;\">Set <\/span>Chart = Report.Sections(\"PageHeader\").Controls(\"E3Chart1\") <span style=\"color: #339966;\"><span style=\"background-color: #ffffff;\">'Stores E3Chart's path at Chart variable's screen <\/span><\/span><\/span>\r\n<span style=\"font-family: Courier New;\"><span style=\"color: #0000ff;\">Set <\/span>Query = Chart.Queries.Item(\"Query1\") <span style=\"color: #339966;\">'Stores E3Chart's Query's path at Query variable <\/span><\/span>\r\n<span style=\"font-family: Courier New;\">Query.SetVariableValue \"InitialDate\", Application.GetObject(\"Data. IniDate\").Value <span style=\"color: #339966;\">'Sets filter's InitialDate variable's value <\/span><\/span>\r\n<span style=\"font-family: Courier New;\">Query.SetVariableValue \"FinalDate\", Application.GetObject(\"Data.EndDate\").Value <span style=\"color: #339966;\">'Sets filter's FinalDate variable's value<\/span><\/span>\r\n<span style=\"font-family: Courier New;\">Query.Execute() <span style=\"color: #339966;\">'Executes the query with the filter <\/span><\/span>\r\n<span style=\"font-family: Courier New;\">Chart.LoadData() <span style=\"color: #339966;\">'Loads query result inside the Chart<\/span> <\/span>\r\n<span style=\"font-family: Courier New;\">Chart.FitAll() <span style=\"color: #339966;\">'Fits data in the axes<\/span> <\/span>\r\n<span style=\"font-family: Courier New;\">Chart.HorScaleBegin = Application.GetObject(\"Data.IniDate\").Value <span style=\"color: #339966;\">'Sets the horizontal axis' initial date <\/span><\/span>\r\n<span style=\"font-family: Courier New;\">Chart.HorScaleEnd = Application.GetObject(\"Data.EndDate\").Value <span style=\"color: #339966;\">'Sets the horizontal axis final date <\/span><\/span>\r\n<span style=\"color: #0000ff; font-family: Courier New;\">EndSub<\/span><\/pre>\n<p>6. Finally, create a Timer tag whose functions are filling the initial and final dates and run the Report&#8217;s <i>Export <\/i>command.<\/p>\n<pre><span style=\"font-family: Courier New;\"><span style=\"color: #0000ff;\">Sub <\/span>Export_OnPreset()<\/span>\r\n<span style=\"font-family: Courier New;\">Parent.Item(\"IniDate\").Value = now-1\/24\/60\u00a0\u00a0 <span style=\"color: #339966;\">'Current time minus one minute <\/span><\/span>\r\n<span style=\"font-family: Courier New;\">Parent.Item(\"EndDate\").Value = now\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 <span style=\"color: #339966;\">'Current time<\/span><\/span>\r\n<span style=\"font-family: Courier New;\">Set report = Application.LoadReport(\"[Report1]\")<\/span>\r\n<span style=\"font-family: Courier New;\">Report.Export \"PDF\", \"C:\\GraphReport.pdf\"<\/span>\r\n<span style=\"color: #0000ff; font-family: Courier New;\">End Sub<\/span><\/pre>\n<p><b>NOTE<\/b>: Attached to this article is a demo application developed with Elipse E3 version 4.5 build 238.<\/p>\n<h3>Attachments:<\/h3>\n<p><a href=\"\/wp-content\/uploads\/2019\/03\/GraphExportUS.rar\">GraphExportUS.zip<\/a><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Many times, a chart report must be exported automatically, with no intervention from the operator. Therefore, the Report&#8217;s Chart object must be set up so that data is moved correctly,&hellip;<\/p>\n","protected":false},"author":9,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0},"categories":[761],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v19.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>KB-63563: Exporting a chart report when E3Chart is not visualized on screen. - Elipse Knowledgebase<\/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:\/\/kb.elipse.com.br\/en\/kb63563-exporting-a-chart-report-when-e3chart-is-not-visualized-on-screen\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"KB-63563: Exporting a chart report when E3Chart is not visualized on screen.\" \/>\n<meta property=\"og:description\" content=\"Many times, a chart report must be exported automatically, with no intervention from the operator. Therefore, the Report&#8217;s Chart object must be set up so that data is moved correctly,&hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kb.elipse.com.br\/en\/kb63563-exporting-a-chart-report-when-e3chart-is-not-visualized-on-screen\/\" \/>\n<meta property=\"og:site_name\" content=\"Elipse Knowledgebase\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/elipsesoftware\" \/>\n<meta property=\"article:published_time\" content=\"2019-03-25T20:43:49+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-07-05T19:24:10+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/kb.elipse.com.br\/pt-br\/images\/ID5026\/Img1.png\" \/>\n<meta name=\"author\" content=\"Daniel Link\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Daniel Link\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/kb.elipse.com.br\/en\/kb63563-exporting-a-chart-report-when-e3chart-is-not-visualized-on-screen\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/kb.elipse.com.br\/en\/kb63563-exporting-a-chart-report-when-e3chart-is-not-visualized-on-screen\/\"},\"author\":{\"name\":\"Daniel Link\",\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/person\/c00158385fccb29f5ff088542d1a1058\"},\"headline\":\"KB-63563: Exporting a chart report when E3Chart is not visualized on screen.\",\"datePublished\":\"2019-03-25T20:43:49+00:00\",\"dateModified\":\"2019-07-05T19:24:10+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/kb.elipse.com.br\/en\/kb63563-exporting-a-chart-report-when-e3chart-is-not-visualized-on-screen\/\"},\"wordCount\":234,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#organization\"},\"articleSection\":[\"Reports\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/kb.elipse.com.br\/en\/kb63563-exporting-a-chart-report-when-e3chart-is-not-visualized-on-screen\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/kb.elipse.com.br\/en\/kb63563-exporting-a-chart-report-when-e3chart-is-not-visualized-on-screen\/\",\"url\":\"https:\/\/kb.elipse.com.br\/en\/kb63563-exporting-a-chart-report-when-e3chart-is-not-visualized-on-screen\/\",\"name\":\"[:pt]KB-63563: Exporting a chart report when E3Chart is not visualized on screen.[:] - Elipse Knowledgebase\",\"isPartOf\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#website\"},\"datePublished\":\"2019-03-25T20:43:49+00:00\",\"dateModified\":\"2019-07-05T19:24:10+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/kb.elipse.com.br\/en\/kb63563-exporting-a-chart-report-when-e3chart-is-not-visualized-on-screen\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/kb.elipse.com.br\/en\/kb63563-exporting-a-chart-report-when-e3chart-is-not-visualized-on-screen\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/kb.elipse.com.br\/en\/kb63563-exporting-a-chart-report-when-e3chart-is-not-visualized-on-screen\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"In\u00edcio\",\"item\":\"https:\/\/kb.elipse.com.br\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"KB-63563: Exporting a chart report when E3Chart is not visualized on screen.\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/kb.elipse.com.br\/#website\",\"url\":\"https:\/\/kb.elipse.com.br\/\",\"name\":\"Elipse Knowledgebase\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/kb.elipse.com.br\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/kb.elipse.com.br\/#organization\",\"name\":\"Elipse Software\",\"url\":\"https:\/\/kb.elipse.com.br\/\",\"sameAs\":[\"http:\/\/www.facebook.com\/elipsesoftware\"],\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2019\/05\/schererelipse-com-br\/logoElipse.png\",\"contentUrl\":\"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2019\/05\/schererelipse-com-br\/logoElipse.png\",\"width\":161,\"height\":58,\"caption\":\"Elipse Software\"},\"image\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/person\/c00158385fccb29f5ff088542d1a1058\",\"name\":\"Daniel Link\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f549886b43447af6d53385f4ed7d575f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f549886b43447af6d53385f4ed7d575f?s=96&d=mm&r=g\",\"caption\":\"Daniel Link\"},\"url\":\"https:\/\/kb.elipse.com.br\/en\/author\/link\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"KB-63563: Exporting a chart report when E3Chart is not visualized on screen. - Elipse Knowledgebase","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:\/\/kb.elipse.com.br\/en\/kb63563-exporting-a-chart-report-when-e3chart-is-not-visualized-on-screen\/","og_locale":"en_US","og_type":"article","og_title":"[:pt]KB-63563: Exporting a chart report when E3Chart is not visualized on screen.[:] - Elipse Knowledgebase","og_description":"Many times, a chart report must be exported automatically, with no intervention from the operator. Therefore, the Report&#8217;s Chart object must be set up so that data is moved correctly,&hellip;","og_url":"https:\/\/kb.elipse.com.br\/en\/kb63563-exporting-a-chart-report-when-e3chart-is-not-visualized-on-screen\/","og_site_name":"Elipse Knowledgebase","article_publisher":"http:\/\/www.facebook.com\/elipsesoftware","article_published_time":"2019-03-25T20:43:49+00:00","article_modified_time":"2019-07-05T19:24:10+00:00","og_image":[{"url":"http:\/\/kb.elipse.com.br\/pt-br\/images\/ID5026\/Img1.png"}],"author":"Daniel Link","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Daniel Link","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/kb.elipse.com.br\/en\/kb63563-exporting-a-chart-report-when-e3chart-is-not-visualized-on-screen\/#article","isPartOf":{"@id":"https:\/\/kb.elipse.com.br\/en\/kb63563-exporting-a-chart-report-when-e3chart-is-not-visualized-on-screen\/"},"author":{"name":"Daniel Link","@id":"https:\/\/kb.elipse.com.br\/#\/schema\/person\/c00158385fccb29f5ff088542d1a1058"},"headline":"KB-63563: Exporting a chart report when E3Chart is not visualized on screen.","datePublished":"2019-03-25T20:43:49+00:00","dateModified":"2019-07-05T19:24:10+00:00","mainEntityOfPage":{"@id":"https:\/\/kb.elipse.com.br\/en\/kb63563-exporting-a-chart-report-when-e3chart-is-not-visualized-on-screen\/"},"wordCount":234,"commentCount":0,"publisher":{"@id":"https:\/\/kb.elipse.com.br\/#organization"},"articleSection":["Reports"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/kb.elipse.com.br\/en\/kb63563-exporting-a-chart-report-when-e3chart-is-not-visualized-on-screen\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/kb.elipse.com.br\/en\/kb63563-exporting-a-chart-report-when-e3chart-is-not-visualized-on-screen\/","url":"https:\/\/kb.elipse.com.br\/en\/kb63563-exporting-a-chart-report-when-e3chart-is-not-visualized-on-screen\/","name":"[:pt]KB-63563: Exporting a chart report when E3Chart is not visualized on screen.[:] - Elipse Knowledgebase","isPartOf":{"@id":"https:\/\/kb.elipse.com.br\/#website"},"datePublished":"2019-03-25T20:43:49+00:00","dateModified":"2019-07-05T19:24:10+00:00","breadcrumb":{"@id":"https:\/\/kb.elipse.com.br\/en\/kb63563-exporting-a-chart-report-when-e3chart-is-not-visualized-on-screen\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kb.elipse.com.br\/en\/kb63563-exporting-a-chart-report-when-e3chart-is-not-visualized-on-screen\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/kb.elipse.com.br\/en\/kb63563-exporting-a-chart-report-when-e3chart-is-not-visualized-on-screen\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"In\u00edcio","item":"https:\/\/kb.elipse.com.br\/en\/"},{"@type":"ListItem","position":2,"name":"KB-63563: Exporting a chart report when E3Chart is not visualized on screen."}]},{"@type":"WebSite","@id":"https:\/\/kb.elipse.com.br\/#website","url":"https:\/\/kb.elipse.com.br\/","name":"Elipse Knowledgebase","description":"","publisher":{"@id":"https:\/\/kb.elipse.com.br\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/kb.elipse.com.br\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/kb.elipse.com.br\/#organization","name":"Elipse Software","url":"https:\/\/kb.elipse.com.br\/","sameAs":["http:\/\/www.facebook.com\/elipsesoftware"],"logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kb.elipse.com.br\/#\/schema\/logo\/image\/","url":"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2019\/05\/schererelipse-com-br\/logoElipse.png","contentUrl":"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2019\/05\/schererelipse-com-br\/logoElipse.png","width":161,"height":58,"caption":"Elipse Software"},"image":{"@id":"https:\/\/kb.elipse.com.br\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/kb.elipse.com.br\/#\/schema\/person\/c00158385fccb29f5ff088542d1a1058","name":"Daniel Link","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kb.elipse.com.br\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/f549886b43447af6d53385f4ed7d575f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f549886b43447af6d53385f4ed7d575f?s=96&d=mm&r=g","caption":"Daniel Link"},"url":"https:\/\/kb.elipse.com.br\/en\/author\/link\/"}]}},"_links":{"self":[{"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts\/3337"}],"collection":[{"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/comments?post=3337"}],"version-history":[{"count":5,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts\/3337\/revisions"}],"predecessor-version":[{"id":7580,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts\/3337\/revisions\/7580"}],"wp:attachment":[{"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/media?parent=3337"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/categories?post=3337"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/tags?post=3337"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}