Hello there,
We recently implemented data encryption at rest in our databases and just stumbled upon a problem on the unexpected end. When we pull data from db it comes encrypted, so in order to show decrypted values we use computed fields in our datawindows and everything works fine.
The problem is when we export data in Excel format using datawindow SaveAs(dw_report, filename, Excel8!, FALSE) function it doesn't export computed fields and exports encrypted values instead.
Is there a good and cheap solution to export datawindow computed fields in excel format?
Thanks,
Boris
I should have mentioned that we have hundreds of datawindows that all can appear in one window and that one window has Export button, so we don't want to check datawindow every time, check columns for existence and we don't want to go through all our datawindows and manually change columns or their types.
We had one line of code and now it doesn't work, so it would be nice to have something as cheap.
PowerBuilders SaveAs to Excel can only export the values in the Primary Buffer. So it doesn't export the layout and also no computed field.
You can find a lot of articels about this problems and some workarounds. Or you check Dw2XLS (http://desta.com.ua/dw2xls/).