I guess that those colums are calculated fields and expressions. You can export the object to an excel file or csv file right clicking on the object and using the contextual menu, or youncan create a button with an action to do the same thing, but like,y more user friendly, you can use the "XL" export to Excel icon in the caption of the same chart.
If you mean you need to do that automatically each time the document is reloadsed by the Server it's not possible, you cannot call that kind of macros within the script or launch them OnPostReload. These will work if you run the reload locally, though.
As I mentioned above, that is not automatic. You will need to create a button that exports to and excel spreadsheet, then LOADs the excel file and store that load into QVD (rather than exporting to a QVD file so you can control the format and layout of the columns (fields) you are storing.
You can work that around creating a Visual Basic program (not a VBScript one) resultin in an exe file, as pointed out in the Automation Reference Manual, that you can schedule to do that process.
Even if you have the module license to export to PDF files in Publisher, that does as a task in the Server, Excel is not a valid format formthe tme being (and unlikely to be in the future) other than this workaround: human interaction to click in that button with actions or the VB project.
The information Joe need to save is not in a table but in a chart, that prevents using the LOAD - STORE part. We are looking for a way of exporting objects to a QVD automatically when the reload finishes and the chart is updated.
As Jagan said you can create a table in the script with the fields and expression you need in chart and store it into qvd. By doing this you dont need to be rely on Macros.
.png "Miguel_Angel_Baeyens"){kind=avatar}
