Whoops... now that I've done that I get Error 0.
--- In vantage@yahoogroups.com, "Aaron Hoyt" <aaron.hoyt@v...> wrote:
> Ben,
> You will need to set up ODBC on the workstation (I am guessing you
have that
> done by the sounds), and you will need to remove the leading ;
from the last
> three or four lines in the .mfg file the users use to launch
Vantage (and
> restart Vantage). They contain the ODBC login information.
> If I am not mistaken the Error 599 will clear up then.
> Good luck,
> Aaron Hoyt
> Vantage Plastics
> A couple of added note for speed.
> Filter the subreport by your company id hard coded, and make sure
you are
> linking the Company field in the links via ODBC. Oh, and if there
is any
> reason you might not want the subreport to show in some
situations, add
> those into the suppress if section for the subreport. Also, make
sure you
> have plenty of ODBC servers setup in your Progress Explorer.
>
> -----Original Message-----
> From: bbelzer42 [mailto:bbelzer@t...]
> Sent: Monday, January 31, 2005 4:25 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Adding Cust. BILL-TO Phone No. in Sales
Order -
> where is it?
>
>
>
>
> Aaron,
>
> I did what you said, and I have a small subreport now with the
field
> I want in it. I linked them, yet now when I try to print I get
> error 599. I think thats the error for "Error connecting to SQL
> Server"
>
> Have you run across this? Did I do it incorrectly?
>
> Thanks,
> Ben
>
> --- In vantage@yahoogroups.com, "Aaron Hoyt" <aaron.hoyt@v...>
wrote:
> > Sue,
> > Create a Subreport in the SOForm. Link by using the order
> number. In the
> > subreport link via ODBC to the Vantage Progress DB. Bring in the
> OrderHed
> > table and then link that to the Customer table via CustNum. In
> the Customer
> > Table you will find the BTPhonNum.
> > This is a bit of a pain if you have not used ODBC to improve
> the "Vantage
> > Standard Exported DBFs" that most all of us have complaints about
> missing
> > data, but once you have done this a time or two, it's really no
> big thing.
> > Good Luck,
> > Aaron Hoyt
> > Vantage Plastics
> >
> > -----Original Message-----
> > From: Susan Iverson [mailto:siverson@j...]
> > Sent: Friday, January 28, 2005 1:02 PM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Adding Cust. BILL-TO Phone No. in Sales
Order -
> where
> > is it?
> >
> >
> >
> > Sales would like to have the BILL-TO PHONE NUMBER added to their
> Crystal
> > SALES ORDERS. I looked at the tables and all I can find is the
> Bill-To
> > Fax and Bill-To Email address fields - but no Bill-To PHONE. Am I
> blind
> > or has Epicor hidden it in another obscure table to torment us?
> >
> >
> >
> > Sue
> >
> > Vantage 6.1 on Progress database Win2000 server.
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> > 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
> > Yahoo! Groups Links
>
>
>
>
>
> 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
> Yahoo! Groups Links