Forms Modification [6.1.533]

Yahoo Archive
1
Brian,

Articles 1189MPS & 2344MPS pointed me in the direction for fixing this
problem. Solution was to change the ODBC server name in the vantage.vtg
file. Our original setup had the system DSN server name as vantage and
the vantage.vtg file ODBC name as progress91d.



Thanks,

Chris



_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Brian Stenglein
Sent: Friday, August 18, 2006 6:03 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Forms Modification [6.1.533]



Keep in mind that you can search ePortal and maybe find the document.

Brian

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Chris Crosta" <chris@...> wrote:
>
> Brian,
>
> Thanks for the information, I have a call into Epicor support but I
> don't think it is very high on their priority list.
>
> I tried inserting a subreport into the report footer but get
error "599"
> when it tries to print the last page.
>
>
>
> _____
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
> Of Brian Stenglein
> Sent: Thursday, August 17, 2006 1:05 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Re: Forms Modification [6.1.533]
>
>
>
> I'm not familiar with this particular form, but in general you need
> to add the table in a subreport via ODBC. Support should have a
> document detailing the steps.
>
> HTH,
>
> Brian Stenglein
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ,
> "Chris Crosta" <chris@> wrote:
> >
> > How do I go about adding fields to a standard form that are not
> > contained in the dbf files and still maintain running it from the
> > vantage menu.
> >
> >
> >
> > I am trying to add the Due Date and Part Number fields from the
> JobHead
> > table to the Job Pick List form.
> >
> >
> >
> > Thank you,
> >
> > Chris Crosta





[Non-text portions of this message have been removed]
2
How do I go about adding fields to a standard form that are not
contained in the dbf files and still maintain running it from the
vantage menu.



I am trying to add the Due Date and Part Number fields from the JobHead
table to the Job Pick List form.



Thank you,

Chris Crosta



[Non-text portions of this message have been removed]
3
I'm not familiar with this particular form, but in general you need
to add the table in a subreport via ODBC. Support should have a
document detailing the steps.

HTH,

Brian Stenglein

--- In vantage@yahoogroups.com, "Chris Crosta" <chris@...> wrote:
>
> How do I go about adding fields to a standard form that are not
> contained in the dbf files and still maintain running it from the
> vantage menu.
>
>
>
> I am trying to add the Due Date and Part Number fields from the
JobHead
> table to the Job Pick List form.
>
>
>
> Thank you,
>
> Chris Crosta
>
>
>
> [Non-text portions of this message have been removed]
>
4
Brian,

Thanks for the information, I have a call into Epicor support but I
don't think it is very high on their priority list.

I tried inserting a subreport into the report footer but get error "599"
when it tries to print the last page.



_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Brian Stenglein
Sent: Thursday, August 17, 2006 1:05 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Forms Modification [6.1.533]



I'm not familiar with this particular form, but in general you need
to add the table in a subreport via ODBC. Support should have a
document detailing the steps.

HTH,

Brian Stenglein

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Chris Crosta" <chris@...> wrote:
>
> How do I go about adding fields to a standard form that are not
> contained in the dbf files and still maintain running it from the
> vantage menu.
>
>
>
> I am trying to add the Due Date and Part Number fields from the
JobHead
> table to the Job Pick List form.
>
>
>
> Thank you,
>
> Chris Crosta





[Non-text portions of this message have been removed]
5
You have to make sure the ODBC connection is installed on the
computer where you are trying to run the report. Make sure to run
the outjoin file.reg on the computer also.

Then, you also have to remove the comments from the Vantage
connection file(Right click on the Vantage icon, and click edit) Then
remove the comments on the last 4 lines where it has the ODBC
parameters. I pasted our file below. (You may want to make 2
versions of this file because if there are any computers using
Vantage that do not have ODBC installed, I do not think they will
connect if the ODBC parameters are not commented out.)

Once you do that, the report should print without the 599 error.

Joe Giannola
Plitek, LLC

--
[MFG Startup]
Executable=W:\progress\bin\prowin32.exe
Database=T:\mfgsys61\db\MFGSYS
IniFile=T:\mfgsys61\mfgsys.ini
ParameterFile=T:\mfgsys61\db\mfgsys.pf
ConnectOptions=-N TCP -H vantage -S 6100 -ld MFGSYS
TempDirectory=C:\Epicor\MfgWrk61
StartupProcedure=mainmenu.w
OtherParameters=-rand 2 -q -basekey ini
mfgsys=VN
mfglanguage=enu
mfgtranslator=yes
unicode=true
*******---------> remove the ";" for these 4 lines <---------****
;MFGODBCpasswd=sysprogress
;MFGODBCUser=sysprogress
;MFGODBCDbse=mfgsys
;MFGODBCServer=Progress91D



--- In vantage@yahoogroups.com, "Chris Crosta" <chris@...> wrote:
>
> Brian,
>
> Thanks for the information, I have a call into Epicor support but I
> don't think it is very high on their priority list.
>
> I tried inserting a subreport into the report footer but get
error "599"
> when it tries to print the last page.
>
>
>
> _____
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of Brian Stenglein
> Sent: Thursday, August 17, 2006 1:05 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Forms Modification [6.1.533]
>
>
>
> I'm not familiar with this particular form, but in general you need
> to add the table in a subreport via ODBC. Support should have a
> document detailing the steps.
>
> HTH,
>
> Brian Stenglein
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> "Chris Crosta" <chris@> wrote:
> >
> > How do I go about adding fields to a standard form that are not
> > contained in the dbf files and still maintain running it from the
> > vantage menu.
> >
> >
> >
> > I am trying to add the Due Date and Part Number fields from the
> JobHead
> > table to the Job Pick List form.
> >
> >
> >
> > Thank you,
> >
> > Chris Crosta
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
6
Keep in mind that you can search ePortal and maybe find the document.

Brian

--- In vantage@yahoogroups.com, "Chris Crosta" <chris@...> wrote:
>
> Brian,
>
> Thanks for the information, I have a call into Epicor support but I
> don't think it is very high on their priority list.
>
> I tried inserting a subreport into the report footer but get
error "599"
> when it tries to print the last page.
>
>
>
> _____
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of Brian Stenglein
> Sent: Thursday, August 17, 2006 1:05 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Forms Modification [6.1.533]
>
>
>
> I'm not familiar with this particular form, but in general you need
> to add the table in a subreport via ODBC. Support should have a
> document detailing the steps.
>
> HTH,
>
> Brian Stenglein
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> "Chris Crosta" <chris@> wrote:
> >
> > How do I go about adding fields to a standard form that are not
> > contained in the dbf files and still maintain running it from the
> > vantage menu.
> >
> >
> >
> > I am trying to add the Due Date and Part Number fields from the
> JobHead
> > table to the Job Pick List form.
> >
> >
> >
> > Thank you,
> >
> > Chris Crosta
>
>
>
>
>
> [Non-text portions of this message have been removed]
>