So I came across an old posting online with a weird crystal issue. The subreport we were using had a parameter field that was not actually being used. I had to delete this from the subreport before it would run in Epicor.
Thanks for the help
Tyler Tisdale
l IT Systems Administrator
ULTRAX Aerospace l 4200 NE Sun Court, Lee's Summit, MO 64064
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, March 02, 2015 10:01 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Added Subreport to PO Form
Ah, no it does not. I had only established the connection inside of Crystal. I will give this a try. Thanks
Tyler Tisdale
l IT Systems Administrator
ULTRAX Aerospace l 4200 NE Sun Court, Lee's Summit, MO 64064
From:
vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, March 02, 2015 9:44 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Added Subreport to PO Form
Does the client station that you’re attempting to run the report from have an ODBC connection to that outside database on it (system DSN)?
Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-3119
FAX: (715)284-4084
[cid:1.234354861@...]<http://www.dsmfg.com/>
(Click the logo to view our site)<http://www.dsmfg.com/>
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, March 02, 2015 9:27 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Added Subreport to PO Form
We had a consultant make a customization for us. Basically he made his own SQL database and populates data from Epicor to it. I took the PO Form and added a subreport to pull data from this outside database. When I run the report from Epicor I get an error
about an invalid field. The reports works fine outside of Epicor, so I assume I need to do something to allow Epicor access to this outside database. Anyone have any ideas to point me in the right direction?
Tyler
[Non-text portions of this message have been removed]