<div>
<div class="content wysiwyg-content">
I'll do my best to explain, I have a report that basically shows Aged status of an order in a warehouse. &nbsp;Currently the report is ran, then exported to Excel, then a pivot table is created around the report with no changes to the data at all. &nbsp;Is there a way to automate this process? &nbsp;I can schedule reports to run at certain times, email out and all that using the server software. &nbsp;I can make a template on the spreadsheet to auto update the pivot. &nbsp;May be a stupid question, but I thought I would ask. &nbsp; Would like to almost make this live?<br />

</div>
</div>


I'll do my best to explain, I have a report that basically shows Aged status of an order in a warehouse.  Currently the report is ran, then exported to Excel, then a pivot table is created around the report with no changes to the data at all.  Is there a way to automate this process?  I can schedule reports to run at certain times, email out and all that using the server software.  I can make a template on the spreadsheet to auto update the pivot.  May be a stupid question, but I thought I would ask.   Would like to almost make this live?


Report Autoexport - Pivot

Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.