If it is known that there is also a way to get out of Baan reports into excel, it is less known fact that you can also format the data using specific macros to be written in VBA. I've seen implemented by a client (the implementation is not mine, and Robert Lano, should be mentioned that) and I decided to bring it back here, because it can be interesting.
And it's interesting because you can extract data in a certain format, perhaps simpler, and then show, for example, in a pivot table, or in a more elegant format.
To do this you first need to define an excel file, to be located in a very specific directory residing on the server (we'll call server_directory).
The excel file actually contains a macro that reads data from a csv file and format them as we want (for example, inserts them into a pivot table, or put them as you like).
done that, you can create a printer device according to the usual fees to excel:
Device Type: Rewrite File
4GL Program: ttstpconv
Topic, ASCII: excel% s C: \\ directory \\ template.xls
Path: FileOut .
csv modifications allowed: Yes
page length: 9999
The only change from the usual is the presence of the path C: \\ directory \\ template.xls.
E 'also necessary that the session that launches the report, before launching a server.to.client run in such a way as to bring the template.xsl file from the directory server to the local user directory C: \\ directory (or find some other method, less tied to specific session, perhaps linked to ttstplopen).
so doing, when in the local file is opened with the command
excel% s C: \\ directory \\ template.xls, automatically activates the VBA template that processes the data file fileout.csv.
If the template contains a subroutine "Sub Auto_Open ()", part of the macro automatically at startup, and you see the formatted data automatically.
It 's interesting, especially in the field of finance, once created a simple report, which writes the data in CSV format, you can then be formatted the same as you want.
