Correct Path Syntax for publishing ODBC Crystal report

What version of Vantage or you on?



We used to use "\\YourServerName\PathToYourReport\ReportName.rpt" Then last
weekend I installed 408b, and after that this wouldn't work anymore. I had
to move all of the files and change all of the paths to
"/CustomReports/ReportName.rpt" which is the folder located in
"\\SERVERNAME\epicor\mfgsys803\Server\reports\".



I have an open call with Epicor about this, but I haven't gotten anywhere.
The tech has tried to say the system is designed to work this way. However,
for the last 4 years I've done it using the UNC path of a folder on the
server and all was fine. Actually, according to the directions Epicor sent
me, this is how they tell you to do it as well (See Below, Step 10).



Hope this helps,



Norman Hutchins

Network Administrator

Howell Laboratories, Inc.

Shively Labs

207-647-3327





Summary: CR "Auto load error" and "Application Load error"

printing

Crystal Reports

Book: Support Solutions

Page: 5140MPS



PROBLEM DESCRIPTION: Printing or previewing any XML style reports fails

with the error "Application Load error" or an "Auto load error" in the

System Monitor. There may also be a "Load Report Failed" message.



May also have the message "System cannot find the path specified.

Inner

stack trace."



May be while trying to run a custom Crystal report that has been added

to

the menu via Menu Maintenance. This may also occur for a standard

Crystal

Report, though that is rare.



PROBLEM RESOLUTION: There are several reasons for these error messages.

Check the following:



1. Go to System Management->Utilities->System Agent. Look at the

Client

Program Directory. It probably has a physical path; try changing it to

a

UNC. Crystal reports should now print.

Example:

\\servername\epicor\MfgSys80\Server
<file:///\\servername\epicor\MfgSys80\Server>



CLOSELY LOOK AT THE SPELLING. "Server" is spelled "Sever". And that's

just not going to work.



2. Go to System Management->Utilities->System Agent. Check the System

AppServer URL, and make certain the server name and port number are

correct

for this AppServer. This can be checked in the Progress Explorer Tool.



3. User needs to have full control over the file to open and print it.



4. If this is a custom Crystal Report, added as a Vantage menu: Go

into

System Management > Security Maintenance > Menu Maintenance and navigate

to

the report menu item in question. Look at the Report Path field. This

value should just be something like

\\ServerName\CustomReports\MyCustomReport.rpt
<file:///\\ServerName\CustomReports\MyCustomReport.rpt> .



5. Go to System Management->Company Maintenance->Report Style

Maintenance,

and select the problem report in the tree on the left. Then select

the

Standard style below it. On the right side, for the company you are

logged into, check the Valid and Default boxes.



6. Go into System Management > Security Maintenance > Menu Maintenance

and

navigate to the report menu item in question. Look at the Report Path

field. This value should just be something like

\\ServerName\CustomReports\MyCustomReport.rpt
<file:///\\ServerName\CustomReports\MyCustomReport.rpt> .



7. Make certain the file name is not too long. If necessary, change

the

actual report name to an 8.3 format, like PackTest.rpt. Also make sure

that

the report name itself does not contain spaces like "Custom Report.rpt".

It

should be CustomReport.rpt.



8. In the Properties for the TaskAgent and ProcessServer AppServers,

there

cannot be an entry for PROPATH the points to a \reports folder before

the

path to \epicor\mfgsys80\server\reports (or mfgsys803\reports).



9. If this occurring on Terminal Server or Citrix clients, but LAN

clients

can print fine, see document 8648MPS.



10. Older functionality in menu maintenance had you add a '-r

\\ServerName\CustomReports\MyReport.rpt
<file:///\\ServerName\CustomReports\MyReport.rpt> ' parameter. The new

functionality

assumes the -r if the program type is Custom Report link. You just need

to

provide the path include the report file name. There is no need for the

-r

parameter anymore.



11. As of patch VN 8.00.802, make certain the Crystal Reports X Runtime

is

installed on this client. These are perquisites necessary on any

Vantage

client that will be printing Crystal Reports forms. If they are

installed,

they will be listed under the Add/Remove Programs Control Panel.



There have been instances where the Crystal X Runtime has not completely

un-installed, and is still visible in the Windows add\remove programs

list.

Check that it is no longer there before attempting a reinstall of the

Crystal X Runtime. Reboot the pc after the app does not appear in the

add\remove programs list. Reinstall the Crystal X Runtime, and when

installing, select install for "all users" option during setup.



12. As of patch VN 8.00.803, make certain the Crystal Report XI Runtime

is

installed on this client. These are prerequisites necessary on any

Vantage

client that will be printing Crystal Reports forms. If they are

installed,

they will be listed under the Add/Remove Programs Control Panel.



There have been instances where the Crystal XI Runtime has not

completely

un-installed, and is still visible in the Windows add\remove programs

list.

Check that it is no longer there before attempting a reinstall of the

Crystal XI Runtime. Reboot the pc after the app does not appear in the

add\remove programs list. Reinstall the Crystal XI Runtime, and when

installing, select install for "all users" option during setup.



13. As of patch VN 8.00.808, make certain the Crystal Report XI R2

Runtime

is installed on this client. These are prerequisites necessary on any

Vantage client that will be printing Crystal Reports forms. If they are

installed, they will be listed under the Add/Remove Programs Control

Panel.



There have been instances where the Crystal XI R2 Runtime has not

completely

un-installed, and is still visible in the Windows add\remove programs

list.

Check that it is no longer there before attempting a reinstall of the

Crystal XI R2 Runtime. Reboot the pc after the app does not appear in

the

add\remove programs list. Reinstall the Crystal XI R2 Runtime, and when

installing, select install for "all users" option during setup.





[Non-text portions of this message have been removed]
Hi, I am trying to publish a working crystal report in menu maintenance on 8.03.305K

However, when I run it up (after saving, closing and re-opening Vantage) I get the message below:

I have tried local and url paths but get the same error.

Where should I locate the report and what is the correct path syntax??


Error Message indicates a path issue -

Load report failed.


Stack Trace
===========
at CrystalDecisions.ReportAppServer.ReportClientDocumentWrapper.EnsureDocumentIsOpened()
at CrystalDecisions.CrystalReports.Engine.ReportDocument.Load(String filename, OpenReportMethod openMethod, Int16 parentJob)
at CrystalDecisions.CrystalReports.Engine.ReportDocument.Load(String filename, OpenReportMethod openMethod)
at Epicor.Mfg.Lib.Report.EpiCrystalViewer..ctor(String rptFile, String usr, String passwd, String rTitle)
at Epicor.Mfg.UI.App.CustomReportEntry.Transaction.previewReport()

Inner Exception
===============
The filename, directory name, or volume label syntax is incorrect.
Inner Stack Trace
=================
at CrystalDecisions.ReportAppServer.ClientDoc.ReportClientDocumentClass.Open(Object& DocumentPath, Int32 Options)
at CrystalDecisions.ReportAppServer.ReportClientDocumentWrapper.Open(Object& DocumentPath, Int32 Options)
at CrystalDecisions.ReportAppServer.ReportClientDocumentWrapper.EnsureDocumentIsOpened()
Hi,



Try this:



\\YourServerName\PathToYourReport\ReportName.rpt
<file:///\\YourServerName\PathToYourReport\ReportName.rpt>



Regards,

Linda



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of sbser2000
Sent: Wednesday, December 09, 2009 6:53 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Correct Path Syntax for publishing ODBC Crystal
report





Hi, I am trying to publish a working crystal report in menu maintenance
on 8.03.305K

However, when I run it up (after saving, closing and re-opening Vantage)
I get the message below:

I have tried local and url paths but get the same error.

Where should I locate the report and what is the correct path syntax??

Error Message indicates a path issue -

Load report failed.

Stack Trace
===========
at
CrystalDecisions.ReportAppServer.ReportClientDocumentWrapper.EnsureDocum
entIsOpened()
at CrystalDecisions.CrystalReports.Engine.ReportDocument.Load(String
filename, OpenReportMethod openMethod, Int16 parentJob)
at CrystalDecisions.CrystalReports.Engine.ReportDocument.Load(String
filename, OpenReportMethod openMethod)
at Epicor.Mfg.Lib.Report.EpiCrystalViewer..ctor(String rptFile, String
usr, String passwd, String rTitle)
at Epicor.Mfg.UI.App.CustomReportEntry.Transaction.previewReport()

Inner Exception
===============
The filename, directory name, or volume label syntax is incorrect.
Inner Stack Trace
=================
at
CrystalDecisions.ReportAppServer.ClientDoc.ReportClientDocumentClass.Ope
n(Object& DocumentPath, Int32 Options)
at
CrystalDecisions.ReportAppServer.ReportClientDocumentWrapper.Open(Object
& DocumentPath, Int32 Options)
at
CrystalDecisions.ReportAppServer.ReportClientDocumentWrapper.EnsureDocum
entIsOpened()





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