Export to Pivot Table at Runtime
Export to Pivot Table at Runtime
I CAN painlessly export one of my reports to an Excel Pivot Table simply using the Export Ole menu choice in RSW.exe, setting up the Pivot parameters then choosing export. When complete I saved the R&R report with pivot parameters.__BUT I^m having difficulty exporting this same report to an Excel Pivot table at runtime.____When I attempt to call the report with a text control file, the report loads successfully, allows me to insert prompted parameters (e.g. a date range), but the report is never exported to an Excel Pivot Table. I can change the RI_PRINTER parameter to D or ? and the report successfully runs from the control file. When I change the RI_PRINTER parameter back to = Excel PivotTable I get nothing.____Here are the contents of my text control file:__RI_REPORT = AP_4CF_Pivot.RSW__RI_PRINTER = Excel PivotTable__RI_EXPDST=F__RI_OUTFILE=AP4CF.xls____For the record I am running R&R ver 12.5.001,Windows8 64bit, using MS Office 2010 and am running R&R against an SQL data master file. Again, the report runs fine and creates a Pivot Table directly from RSW and the same report runs fine at runtime using a text control file as long as I don^t attempt to export to a Pivot Table.________ __
Travel guide places to visit in Italy sightseeing
=> RE: Export to Pivot Table at Runtime
I tried a test this morning to see if I could make it work. Unfortunately, I got the same response (no file, but the status shows that it worked properly).____I^ll place it in the debugger as soon as I can arrange it and see what^s happening that is different from the developer version.
Chris Strasser
Liveware Publishing, Inc.
Work bigger.
Liveware Publishing, Inc.
Work bigger.