The baan report output is in excel format. I just want it in .csv format.
How to configure baan report in comma separated format?
plz reply asap

all u have to do is save the excel file in CSV Fromat(comma delimited).
This option will come when u will "save as" the one excel file u have, there it will ask u for "save as type" here u will have to select CSV Format.

I know that option but I want directly the output in .csv format without using that excel's option. My requirement is whenever you will run the report output should be in notepad and comma separated format.

Thank you so much for ur quick reply

Hi,

you have two options

1) create a report with only detail and put therein different field needed with a comma as separator, output report to ascii file (Device ASCIF) and save it. Potential problem some blank characters in the fields

2) create a session where you read the data and create an ASCII file: see commands seq.open, seq.puts and seq.close. ==> here you can have full control to remove the blank characters.

Regards
Philippe

hii..
is there any possible for save the report as txt file using program ??
without using device i want save the report as text file????

Just because you have a report does not mean you have to ask the user to input the device. Just set the device yourself and use one of the options to not prompt the user for the device. One thing you could do is just create an excel report using comma's instead of pipes - open the report as ascif and write it straight to a file.

This http://www.baanboard.com/baanboard/showthread.php?t=5880&highlight=excel is one example of how to create and excel file. I think there are other options if you search for excel also.