Sage MAS 90 and 200 Sage MAS 500 blogs Product Feedback Support Training
Reply
Super Contributor
Posts: 1,462
Registered: 11-03-2008
0

Custom Crystal Report problem

I recently upgraded a client from 4.3 to 4.4.

 

In 4.3, the custom report completed in about 3-5 minutes.

 

Now, on 4.4, with a virtual server (per the client's preference), the report takes over an hour to run.

 

Aside from implementing the client server ODBC driver, does anyone have other suggestions?

 

MAS 200

 

Thanks

Switcher
BigLouie
Posts: 2,689
Registered: 10-28-2008
0

Re: Custom Crystal Report problem

What tables are you using.

Big Louie No MBA but BMOC
--------------------------------------------------------------------------
You have enemies? Good. That means you've stood up for something in your life.
zip Sage MAS Partner
Sage MAS Partner
zip
Posts: 394
Registered: 11-17-2008
0

Re: Custom Crystal Report problem

What's the performance like without a Virtual Server?  What about other reports?

 

- Brett Zimmerman, brett@oasisky.com
Senior Consultant and Customer Care Manager
c 617-775-8611, www.oasisky.com

Twitter: MAS90_Zip, Member: 90 Minds

Super Contributor
Posts: 1,462
Registered: 11-03-2008
0

Re: Custom Crystal Report problem

Used to run in 3-5 minutes w/o virtual server.

zip Sage MAS Partner
Sage MAS Partner
zip
Posts: 394
Registered: 11-17-2008
0

Re: Custom Crystal Report problem

I was actually asking about the performace without a Virtual Server on the new 4.40 version

And what about other reports?  Are they slow as well?

 

- Brett Zimmerman, brett@oasisky.com
Senior Consultant and Customer Care Manager
c 617-775-8611, www.oasisky.com

Twitter: MAS90_Zip, Member: 90 Minds

Super Contributor
Posts: 1,462
Registered: 11-03-2008
0

Re: Custom Crystal Report problem

[ Edited ]

4.4 has only been installed on a virtual server.

 

The 4.4 upgrade was installed on the virtual server.

 

I'm not sure about the other reports.

 

I suppose some of the other reports will be slow as well.

Sage MAS Partner
VKZIMM
Posts: 768
Registered: 11-10-2008
0

Re: Custom Crystal Report problem

Verify your linkages in Crystal and in Crystal check the File...Report Options for differences.

 

When you install Crystal reports you get different defaults.

 

I had a report and I reversed the link between 2 files and it went from an hour to a few minutes.

 

Super Contributor
Posts: 1,462
Registered: 11-03-2008
0

Re: Custom Crystal Report problem

VKZIMM,

 

I know all the tricks for Crystal Reports in regards to MAS...

 

Again, the same report runs fine in a backup company.

 

The same report is used in 4.4 for all companies, unlike in some previous versions where the rpt could be in company specific directories.