Any tricks to getting crystal rpts to display for 10.1.400?

system · July 12, 2016, 7:31pm

I am currently working on moving our existing Crystal Reports (E9.05.702) to 10.1.400.11.

Here is what I have noticed so far :

- Crystal Reports (.rpt) needs to be in Epicor Data/CustomReports

E9 location Epicor905/Server/Reports/CustomReports

- reports using base RDD, place rpt file in CustomReports folder, no additional changes needed

- reports usingduplicated RDD with no UD tables - place rpt file in customreports folder - print preview the report - take the xml file from EpicorData/Reports and open in Crystal Reports CR Developer to update database links. Preview report, save and place new rpt file in custom reports folder and the report runs correctly

- reports using duplicated RDD and fields from UD tables will need a little bit more work to point to the ice tables instead of the erp tables to find the UD fields.

Regards,
Kristine Fierce

Business Systems Analyst

Ag Leader Technology

system · March 4, 2016, 3:25pm

Xml generates. Vague error in report tab(provides no detail) nothing in the server log, nothing in event viewer, history shows complete no error, never pops up. I have the custom report folder in \\Server\EpicorData\CustomReports

thanks

Rob Bucek

Production Control Manager

D&S Manufacturing

301 E. Main St. | PO Box 279

Black River Falls, WI 54615

715-284-5376 Ext. 311

Mobile: 715-896-3119

rbucek@...

Visit our newly redesigned Website at www.dsmfg.com

system · March 4, 2016, 7:36pm

Hi Rob,

Crystal report must be under server/reports folder and not under CustomReports. It looks like Epicor modified the logic.

Regards,

Arul

Sent from my iPhone

On 5 Mar 2016, at 7:23 AM, Rob Bucek rbucek@... [vantage] <vantage@yahoogroups.com> wrote:

<div id="ygrps-yiv-1191740978ygrp-text">
  
  
  <p>
Xml generates. Vague error in report tab(provides no detail) nothing in the server log, nothing in event viewer, history shows complete no error, never pops up. I have the custom report folder in \\Server\EpicorData\CustomReports

thanks

Rob Bucek

Production Control Manager

D&S Manufacturing

301 E. Main St. | PO Box 279

Black River Falls, WI 54615

715-284-5376 Ext. 311

Mobile: 715-896-3119

rbucek@...

Visit our newly redesigned Website at www.dsmfg.com
</div>

system · March 7, 2016, 9:12am

Rob,

The files should be in \\<Server>\EpicorData\CustomReports\<file name.rpt>

Are you getting the Crystal window to popup? You can also try opening the System Monitor, highlight the report line, then click on Actions > Download Report Data. That might give you more information. If it can't find the file, it will tell you that. Then you know that you are not pointing to the right place the file is stored. Other than that, I would say to check your RDD.

Hope this helps!

Bethany Rye
Epicor Business Analyst
PTI Engineered Plastics

system · July 8, 2016, 5:49pm

Has anyone had any luck with this? I setup my test server to 10.0.700.4 and it was working perfectly fine with crystal, upgraded to 10.1.400 and this no longer works. Loaded the xml to the crystal report to update the tables and it keeps saying COMPLETE but does not generate the report. XML is loaded with the correct data. I tried moving the location around and changing the report style path with no luck.

system · July 11, 2016, 10:43am

You need to move your reports to C:\EpicorData\CustomReports

Rob Bucek

Production Control Manager

D&S Manufacturing

301 E. Main St.

Black River Falls, WI 54615

715-284-5376 Ext. 311

Mobile: 715-896-3119

rbucek@...

Visit our newly redesigned Website at www.dsmfg.com

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Friday, July 8, 2016 4:50 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: any tricks to getting crystal rpts to display for 10.1.400?

Has anyone had any luck with this? I setup my test server to 10.0.700.4 and it was working perfectly fine with crystal, upgraded to 10.1.400 and this no longer works. Loaded the xml to the crystal report to update the tables and it keeps saying COMPLETE but does not generate the report. XML is loaded with the correct data. I tried moving the location around and changing the report style path with no luck.

system · July 11, 2016, 10:50am

I've tried that. Maybe I've got the wrong path on the report style? What is your path for the file in the report style for your reports?

system · July 11, 2016, 10:51am

If you move them to the location Rob indicated, then the path stays the same as it was by default in 9. If you put the custom reports somewhere other than the default location in 9 then Robs suggestion would not work.

Joshua Giese
Technology Solutions : CXO

Direct Phone: 920.593.8299
Office Phone: 920.437.6400 x342

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Monday, July 11, 2016 9:50
To: vantage@yahoogroups.com
Subject: [Vantage] Re: any tricks to getting crystal rpts to display for 10.1.400?

I've tried that. Maybe I've got the wrong path on the report style? What is your path for the file in the report style for your reports?

system · July 11, 2016, 12:24pm

That's strange. Once I upgraded to 10.1.400.13 everything was working again.