1. Yuri Denshchik
  2. PowerBuilder
  3. Thursday, 20 July 2017

When exporting DataWindow to Excel, all hidden columns are exported but visible computed fields are not.  Exporting datawindows to other formats including PDF appears to be fine.

Is there a workaround? If not, can this be fixed? 

Thank you,

Yuri

Chris Pollach Accepted Answer Pending Moderation
0
Votes
Undo
Hi Yuri; That is a known restriction since the feature was added to PB way back when. Here are some suggestions though as a work around to that limitation: 1) Create a DW with SQL computed columns instead of DW computed columns. The SQL computed columns are exportable to Excel 2) Create an External DW with all the columns you need for the Excel data transfer. Then write some PowerScript to transfer the current DWO columns & computations to the External DWO for Excel transference. 3) Use a 3rd party product like DW2XLS that can handle computed columns. FYI: http://desta.com.ua/dw2xls HTH Regards ... Chris
Comment
There are no comments made yet.
  1. Friday, 21 July 2017
  2. PowerBuilder
  3. # 1
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.