Hi all,

I am facing a problem while trasferring a baan report to excel. While transferring the baan report to excel, excel removes leading zero's from the bank a/c field and also the bank a/c number appears in scientific notation.

Is there any way to display the bank a/c number as it is stored in baan. Please advice.

Vishal

HI

Please tell me the steps you are using while exporting data.

Hi there,

I'd guess that the problem isn't the export from Baan but the import into excel. Try to specify the column as "text", then leading zeros won't be removed.

hth
Norbert

Try specifying a ' character as prefix while importing into excel.
excel understands the data following ' char as text.

Or you can also use " " in text.
try importing the attached file into excel ( delimiter = |)

Depending on how you are doing this there are two fixes as mentioned above by others:
(1) Modify the report add quote characters.
(2) On import into excel use text for the field. Then use the text to column features using this.

Now at our site last year when running to excel it would not bring the file in as delimited. See this post (http://www.baanboard.com/baanboard/showthread.php?t=52787) if that is the problem you are having. There for a while when we run a report to excel, the first thing we have taught our users is to close the file. Then use the File and select the first from the history list. This is the temp file just downloaded. Then step thru the import wizard and select text for the appropriate fields.

HI

Please tell me the steps you are using while exporting data.

Hi,
The report is exported directly to Excel using the ERPJewels tool.

Vishal

U can use UDF of string domain long enough for this purpose . e.g. ur bank account variable is bankac which is displayed as say F420 in selection zoom for input parameters . All u need to write in UDF text is the following code .


return ("'" & F420)

And use this udf in query fields as against original bankac . U dont need to change the original report for this .

U can use UDF of string domain long enough for this purpose . e.g. ur bank account variable is bankac which is displayed as say F420 in selection zoom for input parameters . All u need to write in UDF text is the following code .


return ("'" & F420)

And use this udf in query fields as against original bankac . U dont need to change the original report for this .

Yes Hitesh Sir,
Using UDF it works. Also, concatenating ("'" & tccom025.bano) in the session script also works.

Thanks a lot,
Vishal