Databases
StackOverflow2013
Postsdbo
POExport Data on Chart to Excel/CSV LogiXML
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POExport Data on Chart to Excel/CSV LogiXML
    text
    copied!<p>I have a very simple question. I have been trying to export a set of data (2 columns) from a data-layer that is currently being used on a graph. What I am trying to accomplish is, to obtain the data enclosed in that graph and present it in an excel or csv spreadsheet as data (not the actual graph). I want to know if this is possible without creating a separate data table and linking the export to that. I have tried multiple Action.Export to accomplish this, but I am at a point where I'm not sure if it can be done.</p> <p>I appreciate any help I might get. Thank you!</p> <p>UPDATE: This is the modifications I made to your report David, to recreate my issue:</p> <pre><code> &lt;Body&gt; &lt;Dashboard2 SaveFile="@Function.AppPhysicalPath~\SavedDashboards\Dashboard.xml" DashboardAdjustable="True" AllowFreeformLayout="False" DashboardTabs="True"&gt; &lt;Panel ID="pnl1" Caption="pnl1" MultipleInstances="True"&gt; &lt;PanelContent&gt; &lt;Division ShowModes="rdExportCsv" ID="divTable" IdeDisplayStatus="Collapsed"&gt; &lt;DataTable ID="table"&gt; &lt;DataLayer Type="Static" ID="dlStatic1"&gt; &lt;StaticDataRow columnA="Test 1" columnB="100" /&gt; &lt;StaticDataRow columnA="Test 3" columnB="110" /&gt; &lt;StaticDataRow columnA="Test 2" columnB="105" /&gt; &lt;DataLayerLink ID="linkData" /&gt; &lt;/DataLayer&gt; &lt;AutoColumns /&gt; &lt;/DataTable&gt; &lt;/Division&gt; &lt;Division ID="divChart" ShowModes="rdBrowser" IdeDisplayStatus="Collapsed"&gt; &lt;Chart Type="XY" ChartDataColumn="columnB" XYChartType="Bar" ChartHeight="260" ChartWidth="400" ChartLabelColumn="columnA"&gt; &lt;DataLayer Type="Linked" LinkedDataLayerID="linkData" /&gt; &lt;/Chart&gt; &lt;/Division&gt; &lt;Button ID="ExportCSV" Caption="Export CSV" IdeDisplayStatus="Collapsed"&gt; &lt;Action Type="CSV"&gt; &lt;Target Type="CSV" ExportDataTableID="table" /&gt; &lt;/Action&gt; &lt;/Button&gt; &lt;/PanelContent&gt; &lt;/Panel&gt; &lt;/Dashboard2&gt; </code></pre> <p></p> <p>After clicking the export button, it exports to a CSV file, but with the error I mentioned in the comments below. Any ideas? Thank you!</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload