Report Autoexport - Pivot
Posted on 2008-10-01
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?