Login
Register
Search
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Forums
Performance Management
Lawson Business Intelligence/Reporting/Crystal
Page Setup or Print takes over a minute to open in Crystal
Home
Forums
Jobs
LawsonGuru
LawsonGuru Letter
LawsonGuru Blog
Worthwhile Reading
Infor Lawson News Feed
Store
Store FAQs
About
Who's On?
Membership:
Latest:
Jessica
Past 24 Hours:
0
Prev. 24 Hours:
1
Overall:
5192
People Online:
Visitors:
193
Members:
0
Total:
193
Online Now:
New Topics
Lawson Landmark
Executing IPA from PR160
5/3/2024 2:46 PM
We're facing a situation where we need to upda
IPA/ProcessFlow
Executing IPA from PR160
5/3/2024 2:46 PM
We're facing a situation where we need to upda
S3 Customization/Development
Cobol - Extract Current Time
4/24/2024 7:21 PM
How do you extract just the Current System Time in
Lawson Landmark
LPL INSTR Functions
4/5/2024 8:32 PM
I'm writing a simple report using the Create R
Infor SCM
Translating 856 to get the ~ REF^CN^ field
4/3/2024 8:24 PM
We are trying to get the tracking number which is
IPA/ProcessFlow
Sample XML file create Flow
4/3/2024 3:43 PM
Hello everyone, I am new to creating XML files
Lawson S3 HR/Payroll/Benefits
bn105 error message
3/26/2024 6:40 PM
I need to change some of the set ups in our Life I
IPA/ProcessFlow
IPA executing Job
3/13/2024 7:08 PM
New to the IPA world and was wondering, can an IPA
Lawson S3 HR/Payroll/Benefits
Life Age Reduction on benefits plans
3/12/2024 7:15 PM
For our optional life we have an age based coverag
Lawson S3 HR/Payroll/Benefits
BN53.1 Add-In
3/7/2024 3:31 PM
We are migrating to Solstice. They require a
Top Forum Posters
Name
Points
Greg Moeller
4184
David Williams
3349
JonA
3288
Kat V
2984
Woozy
1973
Jimmy Chiu
1883
Kwane McNeal
1437
Ragu Raghavan
1354
Roger French
1311
mark.cook
1244
Forums
Unanswered
Active Topics
Most Liked
Most Replies
Search Forums
Search
Advanced Search
Topics
Posts
Prev
Next
Forums
Lawson Business Intelligence/Reporting/Crystal
Page Setup or Print takes over a minute to open in Crystal
Sort:
Oldest First
Most Recent First
You are not authorized to post a reply.
Author
Messages
Mary Porter
Veteran Member
Posts: 337
4/25/2013 7:13 PM
When we access Page Setup while in Crystal it takes over a minute to come up - the same thing when we click on Print - has anyone ever had this happen before?
It happens to all of us that are developing reports in Crystal Reports 2008.
Matthew Nye
Veteran Member
Posts: 514
4/26/2013 1:43 AM
Id bet this is a printer setup issue. do you have similar issues when printing from other desktop apps?
John Henley
Senior Member
Posts: 3349
4/26/2013 10:32 AM
Mary, are you seeing this when running crystal on the server or your desktop? I would look at two things. What is the default printer and where is it in the network. Also are you using "page x of y" in your report?
Mary Porter
Veteran Member
Posts: 337
4/26/2013 3:21 PM
It happens from any of our desktops when we use any network printer - we tried Adobe PDF as a printer too - and it happens on any report
whether we use page x of y or not.
John Henley
Senior Member
Posts: 3349
4/26/2013 8:19 PM
Does it matter how much data is in the report?
Mary Porter
Veteran Member
Posts: 337
4/26/2013 8:39 PM
Data doesn't appear to have any bearing - if I just create a blank report and then open up page setup it still takes over a minute to open
John Henley
Senior Member
Posts: 3349
4/27/2013 12:02 AM
What about other apps, are they also slow to bring up the page setup?
How many printers are defined on the machine?
Matthew Nye
Veteran Member
Posts: 514
4/27/2013 3:37 AM
I actually had a client with this issue a long time ago im pretty sure. i really need to start logging these. What version of Crystal are you on? Have you tried apply SP4 if youre on XI R2? Also, just to isolate, try checking No Printer in Page Setup and see if that problem goes away. I think its pretty obvious that its printer driver related but just to be sure.
Mary Porter
Veteran Member
Posts: 337
4/29/2013 7:10 PM
We are on Crystal 12.3.0.601 and checking No Printer does not change the file open time. And we have tried SP4.
I checked my machine and there are 40 printers defined - most of which I don't use - so I deleted all of them except
for the 4 that I use and it took my opening time down to about 15 seconds. So is that closer to normal or should it be
instantaneous?
Mary Porter
Veteran Member
Posts: 337
4/29/2013 7:49 PM
Deleted all printers except for 1 and Adobe PDF - opening time is now 4 seconds.
The.Sam.Groves
Veteran Member
Posts: 89
4/29/2013 8:14 PM
Mary, I'm making assumptions here based off what you've said, but it sounds as if you are on the network of at least a semi-large company if you've got over 40 printers avaliable to print on. Which would imply that your network admin has intelligently broken up the internal network into a group of subnets.
In this event, the likely issue is that the printers you are attempting to print to are not on the same subnet as you are.
When you open the print window, Windows queries all the network printers you have set up to update their queue status (along with other things) using SNMP. SNMP by default does not cross subnet boundries to prevent the entire network from drowning in the traffic. So Window's query never actually reaches the printer.
As a result, printers that aren't in the same subnet as you will 'hang' the print dialog as Windows waits for the 'appropriate' timeout to the SNMP request.
And since Windows also tries to be 'polite', it'll queues up the requests, only sending out a new batch as requests are completed or time out. As a result, if you've only got a few printers installed, you'll get a short delay since all their queries are sent out at the same time and you only have one 'timeout' wait. But when you've got a bunch, you can hang for minutes as Windows works its way through the list, waiting for the previous set to timeout before sending off a new set.
I'm afraid the few times I've run into this issue I've only discovered two real solutions and one theoretical:
1. Install/Find a printer on the same subnet as you and use it instead of the others. Remove the rest so you don't hang while Windows queries them - this is the easiest IMO.
2. For each printer you need that you can't get on your own subnet, go into the properties of the printer and under the PORTS tab, make sure bidirectional is unchecked for the port being used. This may be difficult if your IT/IS department is attempting to protect you from yourself and has locked down those settings. This may also have other repercussions that are printer specific.
In theory, you could also ask your IT group if it were possible for them to set it up so SNMP packets were routed between subnets your subnets. It is doable, and if they have any router savy and are setup correctly, fairly easy (I'm told).
But experience tells me that if you are in this sort of situation in the first place it's either because they aren't setup to handle it or because they had a reason not to do it in the first place.
This of course is all based on assumptions, but it was the general cause behind this sort of problem every other time I've run into it.
Mary Porter
Veteran Member
Posts: 337
4/29/2013 8:58 PM
Thank you all very much for the explanations - very logical - I really appreciate it! My systems guy tells me that 4 seconds is pretty darn good for crystal,
and so I'm happy as will be everyone that writes in crystal here. I sent the last reply from The.Sam.Groves to our systems people so if there is anymore information
to share about our environment I will put it in here.
You are not authorized to post a reply.