1. Yuri Denshchik
  2. PowerBuilder
  3. Thursday, 20 July 2017 23:24 PM UTC

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 @Appeon Accepted Answer Pending Moderation
  1. Friday, 21 July 2017 02:52 AM UTC
  2. PowerBuilder
  3. # 1
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.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.