Hi,

Testing from servers console, set the Windows default printer to the Microsoft XPS Document Writer and retry Preview of a report.

John Nichols

Sage

Sage 100 ERP  Standard or Advanced?

How much memory is being allocated to the citrix workstation session?

Sage 100 ERP Advanced.

The 12G of memory is for the Citrix server that users are logging into and running workstation.

The server that hosts ERP has 8G of ram.

The same printer delay issue present with XPS set as default.

All users printers use the Citrix Universal Printer driver.

"AV has exclusions for all sage/crystal directories and *.rpt" - confirm that this is on the server's AV configuration.

Separate application server and Citrix servers or all-in-one?

Not sure if the client-server ODBC driver would help in this configuration, but might be worth exploring.

Separate ERP host server and Citrix ERP workstation server.

AV exclusions have been set for both servers.

The Server that has ERP the reports work correctly

Citrix server I am still having issues

Unable to pull up ODBC connection options with he x64 admin, works with the x86 version.

Only shows as a user DSN

What would I be checking with the ODBC?

You didn't mention how much of the 12GB on RAM on is being allocated to each user logging in?  Minimum workstation configuration is normally 2 GB of RAM,  but more speeds things up (or should I say less slows things down).

Have you tried logging in from the ERP server itself and seeing if the same slowness occurs?

Almost sounds like there is a low speed connection between the Citrix server and the server hosting Sage 100.   Since crystal does not truly operate in a C/S mode,  reports in crystal can run agonizingly slow if the connection speed is low.

I would bet on using trying client server odbc driver at this time.   May or may not help, but it's worth a try.

The Citrix server is like a terminal server all connected users share the 12GB of RAM. While testing there are no other users connected so all 12G are available.

The two servers Citrix & ERP are on the same VMware host. They are connected with a 10G nic and have good speeds when testing with file transfers from SMB shares.

What should I be testing with the ODBC?

I'm no expert on Citrix Server | Terminal Server | Remote Desktop services but my understanding is that the maximum memory allocated per user can be set.   If the maximum memory per user is set too low it could cause slowness.

I read somewhere once that the default is 1/2 GB?   That seems absolutely ludicrous to me so I'm not sure how accurate that is.

Apologies,  this youtube below is kind of rudimentary.

www.youtube.com/watch

As regards the ODBC, it's not so much a matter of testing it as trying the C/S ODBC driver.  You should be able to find instructions on installing it in the installation guides or check in with your reseller.  Normally if all workstations are local (not remote low speed connections) this should not make a difference, but you have some odd things going on so it's worth a shot.

Resource management for individual sessions is not enabled on the citrix server. All users have access to the full 12G memory. I will contact my vendor and and ask them about ODBC setup.

Print preview from the ERP server works just fine.  

How many user sessions are typically going at any one time?

If you had 10 sessions running simultaneously I could see things slowing down because there just isn't enough memory to go around.