OGM123
22nd February 2016, 11:47
hi,
I was making a report to excel and when i print it doesnt show the description of the record. It shows the equivalent code instead. can someone help me with this?
mark_h
22nd February 2016, 15:33
I am sure someone can help if you post the relevant code. That might allow us to see exactly what you are doing.
bdittmar
22nd February 2016, 15:56
hi,
I was making a report to excel and when i print it doesnt show the description of the record. It shows the equivalent code instead. can someone help me with this?
Hello,
in BaaN IV :
itemcode = tiitm001.item
item descr. = tiitm001.dsca
put both fields in your Report (Output).
Regards
Ajesh
23rd February 2016, 06:43
Do you mean to say when you are printing it on the Display Browser you can see the field "description" but when you print it to ASCII Mode and then transfer it to Excel file , you cannot see the description?
OGM123
23rd February 2016, 10:46
Do you mean to say when you are printing it on the Display Browser you can see the field "description" but when you print it to ASCII Mode and then transfer it to Excel file , you cannot see the description?
For example:
In printing report.
Item Company
Mouse Microsoft
In Excel:
Item Company
Mouse S10000980
I want it to display as microsoft also. not the company code.
bhushanchanda
24th February 2016, 07:47
Hi,
You need to get the Description/Name using programming or by using that particular field on your report layout. It won't appear automatically.
e.g. If you use tccom100.bpid, it will give you the code.
If you give tccom100.nama it will give you the name
You can give the name of the table you are using to print the data and someone might suggest you a clue.