Using Sub-Report on ARForm in Vantage

Yahoo Archive
1
I think you have to edit your vtg file and take the ";" off of the odbc
lines
I think these are the last four lines of the file.

Frank Zeigafuse
Innovative Office Products
General Manager
Direct Phone: 610-559-6369
Email: fzeigafuse@...

Visit www.one.org to see how the world can be changed one person at a time.



-----Original Message-----
From: PLAMAN DICK [mailto:dick.plaman@...]
Sent: Wednesday, June 29, 2005 1:44 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Using Sub-Report on ARForm in Vantage


Patrick and Todd,
I took your advice and attempted to place a sub-report on the ARForm in
Vantage to get the sales order from the RMADtl table. It works very well
while in Crystal Reports designer, but when I call it from the Vantage menu,
I get an error 599. I have a ODBC account that is read-only and while in
designer, I am prompted for the password for this account. When I run from
Vantage, I never get the prompt, just the error. The report is designed to
use the run-time parameters for linking the sub-report from the main report
(InvcDtl.CompanyID to RMADtl.Company, and InvcDtl.RMANum to RMADtl.RMANum).
I looked at Epicor's web-site for error 599, but so far, the document does
not help.

thanks for your help.


[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
2
Patrick and Todd,
I took your advice and attempted to place a sub-report on the ARForm in
Vantage to get the sales order from the RMADtl table.
It works very well while in Crystal Reports designer, but when I call it
from the Vantage menu, I get an error 599.
I have a ODBC account that is read-only and while in designer, I am
prompted for the password for this account.
When I run from Vantage, I never get the prompt, just the error.
The report is designed to use the run-time parameters for linking the
sub-report from the main report (InvcDtl.CompanyID to RMADtl.Company,
and InvcDtl.RMANum to RMADtl.RMANum).
I looked at Epicor's web-site for error 599, but so far, the document
does not help.

thanks for your help.


[Non-text portions of this message have been removed]
3
There are several lines in the vantage.mfg file (in 6.x - vantage.vtg earlier) than need to be uncommented out (remove the ; ).
They look like:
;MFGODBCpasswd=sysprogress
;MFGODBCUser=sysprogress
;MFGODBCDbse=mfgsys
;MFGODBCServer=Progress91D

I think these assume too that the Progress9.1D DSN is being used for ODBC.

Also in some cases there is an outer join fix that needs to be run that can cause 599 but that does not appear to be your case. Worth looking at the Epicor site and searching for it. But I would bet the MFGODBC lines are still commented and should be activated - then have the user exit vantage and re-enter.

-Todd C.

-----Original Message-----
From: PLAMAN DICK [mailto:dick.plaman@...]
Sent: Wednesday, June 29, 2005 12:44 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Using Sub-Report on ARForm in Vantage


Patrick and Todd,
I took your advice and attempted to place a sub-report on the ARForm in
Vantage to get the sales order from the RMADtl table.
It works very well while in Crystal Reports designer, but when I call it
from the Vantage menu, I get an error 599.
I have a ODBC account that is read-only and while in designer, I am
prompted for the password for this account.
When I run from Vantage, I never get the prompt, just the error.
The report is designed to use the run-time parameters for linking the
sub-report from the main report (InvcDtl.CompanyID to RMADtl.Company,
and InvcDtl.RMANum to RMADtl.RMANum).
I looked at Epicor's web-site for error 599, but so far, the document
does not help.

thanks for your help.


[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

<?---- LSpots keywords ?><?---- HM ADS ?>

_____

YAHOO! GROUPS LINKS



* Visit your group " vantage <http://groups.yahoo.com/group/vantage> " on the web.


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .


_____




[Non-text portions of this message have been removed]