Hi,
Please tell me how can I use vB code in baan?

I want to increase font size of perticular field on report from script.

Size
The tag allows you to change the size of your text.
Usage [size=Option]value
Example Usage this text is two sizes larger than normal
Example Output this text is two sizes larger than normal

Any other option please help without changing registry setup & fonts for each client setting etc.

Thanks,
Biswajyoti Panda

Hi,

There are multiple options to do that-

1. Check the Font-size in report properties. Also, before printing the report, you can select preview option and set the font size for that report and save it as default whatever you like.
2. Create a report using HTML
3. Create a report using OpenXML
4. Build your own program using IText in Java to print PDF report
5. Create a report using any reporting tool BIRT/SSRS/Crystal
6. If you use it frequently, you can buy a tool like Hidox (http://www.baanboard.com/node/3306)

Or if you want to go beyond that, create a tool to read a file and design it using any language you want.

Hi,

Thanks for your reply.

I think if I can create a device to get the output in HTML format & in device script I will edit the HTML file to increase font size.

I tried this one also but, the barcode is not appearing on the HTML file.
It is appearing as on device "D".
So any option is there to keep the barcode output as it is on HTML file or I need to create barcode in HTML itself?

If need to create the please provide a sample script to create barcode in html.
I am using bc$(1005,6,text,...)
i have attached the Baan barcode output, I need similar output.

Thanks & Regards
Biswajyoti Panda

Hi,

Never done that, but you can try using Barcode generators to create one and use that in your HTML report.

Some threads which might help:-

1 (http://www.jqueryscript.net/other/Simple-jQuery-Based-Barcode-Generator-Barcode.html)
2 (http://code.google.com/p/jquery-barcode/)
3 (http://barcode-coder.com/en/barcode-jquery-plugin-201.html)
4 (http://www.barcoderesource.com/htmlBarcode.shtml)

BTW... how many fields do you want to toggle ??

Hi,

My report contains 2 fields (Lot code & Barcode of lot code)


Thanks & Regards,
Biswajyoti Panda

Hi,

Can anyone suggest me if I can raise this issue with infor?

Thanks & Regards
Biswajyoti Panda

Hi,

If you follow my first suggestion you can do it.

Set font type as User Defined for those 2 fields. Now, when you print the report on client machine using Device Type as Windows Printer, you can select preview option and set the font size, style etc as needed for those 2 fields i.e. field and barcode. You can save that as default. There is no need of changing the registry.

I guess, Infor will recommend you the same thing. Other than this, there are number of ways to customize it.

Hello Bhusanchand,

Setting the font size & style on preview mode needs to be done on each computer I think.

If yes, then I can't go with that option to change on every user's system.

Thanks & Regards
Biswajyoti Panda

Hi,
Yes. It needs to be done on each client machine. But aFAIK, that't what standard offers for now. Other than that, you need to create your own tools/device to do that.

if you are using bwprint , i think you can set the fonts on report level as large , medium and small ( i dont think this should be done in individual client system ), if you want that in ERPLN printer than you have to tweak the printer driver on server level ( although i dont know how to do that)

If you want to toggle between font ( you can do that using to layouts with different fonts)

Yes,

LN offers you max 10 characters per inch size. If you can manage with that, you can use the solution Vamsi suggested and it won't require settings at each client. You require individual setup only in case of User Font. But looking at the font size you need 10 cpi might not fit.

Hello,

Is there any way to know which user fonts are already used or which user fonts already used in which report...?

Thanks & Regards
Biwajyoti Panda

Hi,

If you want to know about the fonts used at the report level you can query table ttadv330. If you want to know the fonts used at field level, you can query table ttadv334.