Method:Classic General Q&A

Re: Formatting grid values?

Anonymous — Wed, 16 May 2012 21:41:34 GMT

smohyee:
do you have a suggestion for the override script?

I got a tip from a team member here that if you use QuantityOnHand as your SQL Override on the item grid column for Quantity On Hand you'll have the display with no decimal places.

Re: Formatting grid values?

Anonymous — Tue, 15 May 2012 21:02:48 GMT

smohyee:
do you have a suggestion for the override script?

I know a little SQL but not enough to advise you on the script. CONVERT is probably the function you want in this respect and the best I can do is link you to an MSDN article that explains this function a little more. If you need help with writing the SQL you can definitely contact one of our consultants on this.

Re: Formatting grid values?

smohyee — Tue, 15 May 2012 17:46:49 GMT

Chad, I'm not an SQL programmer, do you have a suggestion for the override script?

From what I've read, SQL is not really designed for formatting displayed information, but the best functions I could find are CAST and CONVERT. The following script doesn't display any values in my quantity column:

SELECT CAST(viewaccItem.QuantityOnHand AS INT) FROM viewaccItem (I also have different WHERE statements I've added to the end, based off your sript generator's recommondations)

Re: Formatting grid values?

Anonymous — Fri, 11 May 2012 16:27:53 GMT

Smohyee,

You could use a SQL override here - I hadn't thought of this earlier but it is possible to override what's shown in a grid with this feature.

Re: Formatting grid values?

Anonymous — Fri, 11 May 2012 15:26:37 GMT

smohyee:
Can I modify the display format of grid values?

Not at this time, you would have to recreate the field in the table to adjust the decimal places. See this post.

Formatting grid values?

smohyee — Thu, 10 May 2012 23:18:27 GMT

Hi all.

I know that for individual fields placed on the screen, we have some control over the format of display, eg the number of decimal places for currency values.

Can I modify the display format of grid values? For example, the "Quantity" column of my Item grid displays with two decimal places ("4.00"), and I'd like it to only display the integer.