How to export a datawindow into a text file.

dw_1.saveas()


Look at the help file...there is even an Excel saveas datatype...

There's also the function dw_1.SaveAsAscii()

thanks for your swift reply, but when i tried that its generating a raw data. what i want is the same presentation as the report data window including the columns with formula. i have read 1 post about the data store? is this applicable?

You can also save the dta direct in excel.

dw_1.SaveAs("path_with_filename", EXCEL!, TRUE)

You can also open a cold link and transfer data direct to excel.

See in Help SetRemote() function.


Please let us know how you want to save data in file, as excel or text.


Best regards

Bhatti

Preferably i want it in excel, because that is what our accounting people are using. i want to capture the exact presentation as my report data window. what they are doing right now is printing the data window and then encoding the figures in their excel files. example of which is our Daily Sales Report which includes the sales of our seven stores. so instead of entering it one by one. they will just copy the file and paste it in their's.  this reduces the error of keying the wrong figures in their report. the saveas() function only gives me the raw data. what i need is the processed one. that is why i trying the "print to file" option. but its giving me garbage. what am i doing wrong?

in PB9 you're able to export (saveas) XML (layout as well as data). From there you can go anyway you like.

a million thanks to you!!!! the saveasAscii() did work!