ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> RTM Reports & Editing >> Modify field or display mask
http://www.istechforum.com/YaBB.pl?num=1328107258

Message started by gtladmin on 02/01/12 at 07:40:58

Title: Modify field or display mask
Post by gtladmin on 02/01/12 at 07:40:58

Shipping says they need to have a comma show up in the various quantity fields on the packing lists so they make less mistakes (mis-reading 10000 vs 1000, stuff like that). ANYWAY, I tried to see how to do that in the RTM and can't seem to figure it out. I scanned the boards already and only one item came up where someone tried to change the display mask but it didn't work.

How do you do this, or can't it be done?

Thanks,

Val

Title: Re: Modify field or display mask
Post by GasGiant on 02/01/12 at 08:24:38

Have a look at this link, which explains how to use Display Format in the Form Editor

http://www.cassoftware.com/tas/manual/index.html?displayformat.htm

Title: Re: Modify field or display mask
Post by gtladmin on 02/01/12 at 09:19:42

Ok, I am at the same point the poster from 2005 was. After finally finding the link for the Display formats in the suggested URL, I see this: "DisplayFormat The DisplayFormat property is used to control how data is formatted for a report. For example, '#,0' would display 10000 as 10,000." Well I have already tried that rendition and all I get when the packing slip prints is ,0. The data in the field does not print.
I've also tried #,330, #,##0.00. All that prints is the comma and the decimal, not the actual quantity number.

Also the page says this: "Display format Property Editor: To use the Built in property editor lookup. After you have placed a dbtext or dbcalc right click on the object you have placed on your report and the following menu will be displayed.......Click on the display format menu option. and the following property editor menu will be displayed. Choose the display format you wamt to use and click ok. ..." Nope, the available display formats are blank, i.e., there is nothing there.

So is this a wild goose chase?

Title: Re: Modify field or display mask
Post by gtladmin on 02/02/12 at 09:31:54

Ok, well, I guess you can't do this in the report editor, so I've let shipping know they just have to do a better job actually reading the packing slips.

Thanks anyway.

Title: Re: Modify field or display mask
Post by Lynn_Pantic on 02/02/12 at 10:53:17

cassoftware.com is a different version of TAS than what we use so things mentioned on that site may not work in Evo.

Title: Re: Modify field or display mask
Post by kchri on 08/31/12 at 08:27:27

So is there a way to format then? I also looked up the link and the formatting they suggested does not work.

I want to format the QTY field for example to not display as 1.000000 but to display 1.00 instead. Any idea how to do this?

Title: Re: Modify field or display mask
Post by Lynn_Pantic on 08/31/12 at 13:29:17

It is not something you can change within the report editor. Programming would have to create a variable that is formatted the way you want it and then you could add that variable to the form.