Created a new variable TEST = TONumber({invchead.INVCNUM}), had the invoice
group sort on this field. Problem fixed.
Sincere Thanks to those who responded off list.
Patrick
No Thanks to tech support who will bring this up at next weeks meeting.
Whatever!
-----Original Message-----
From: pjw@... [mailto:pjw@...]
Sent: Wednesday, August 20, 2003 11:15 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal AR Customer Statement
The form does not sort properly after 99999 invoices, 100000 and above sort
first.
The form is sorting like a character field would from left to right not in
numeric order.
Any comments would be appreciated.
Tech support incident number 886293.
Patrick Winter
sSc Specialty Screw Corporation
Vantage 5.10.130, Progress 9.1C
[Non-text portions of this message have been removed]
------------------------ Yahoo! Groups Sponsor ---------------------~--> Buy
Ink Cartridges or Refill Kits for Your HP, Epson, Canon or Lexmark Printer
at Myinks.com. Free s/h on orders $50 or more to the US & Canada.
http://www.c1tracking.com/l.asp?cid=5511
http://us.click.yahoo.com/l.m7sD/LIdGAA/qnsNAA/PhFolB/TM
---------------------------------------------------------------------~->
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
group sort on this field. Problem fixed.
Sincere Thanks to those who responded off list.
Patrick
No Thanks to tech support who will bring this up at next weeks meeting.
Whatever!
-----Original Message-----
From: pjw@... [mailto:pjw@...]
Sent: Wednesday, August 20, 2003 11:15 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal AR Customer Statement
The form does not sort properly after 99999 invoices, 100000 and above sort
first.
The form is sorting like a character field would from left to right not in
numeric order.
Any comments would be appreciated.
Tech support incident number 886293.
Patrick Winter
sSc Specialty Screw Corporation
Vantage 5.10.130, Progress 9.1C
[Non-text portions of this message have been removed]
------------------------ Yahoo! Groups Sponsor ---------------------~--> Buy
Ink Cartridges or Refill Kits for Your HP, Epson, Canon or Lexmark Printer
at Myinks.com. Free s/h on orders $50 or more to the US & Canada.
http://www.c1tracking.com/l.asp?cid=5511
http://us.click.yahoo.com/l.m7sD/LIdGAA/qnsNAA/PhFolB/TM
---------------------------------------------------------------------~->
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/