Solved

crystal reports XI on windows 7 from XP

Posted on 2014-02-21
16
496 Views
Last Modified: 2014-03-10
I have a process to print cheques with a 4 inch depth (rather than 11 inch).
This report has been set up in crystal xi and the Print Server Properties have a form called "Cheques"  with 4 inch depth. The printer is attached to a windows 7 64 bit box and that also has a form depth of 4 inch defined for Cheques.
This all worked very well under the old XP regime.
With Windows 7 I now only get the standard listing paper between each cheque!

Can anyone PLEASE help?
Keith66miners
0
Comment
Question by:keith66miners
  • 7
  • 5
  • 2
  • +1
16 Comments
 
LVL 18

Expert Comment

by:vasto
Comment Utility
This might be related to the printer , not the report
0
 
LVL 7

Assisted Solution

by:Lee Ingalls
Lee Ingalls earned 100 total points
Comment Utility
You may need to define a custom page size in the Printing Preferences - Paper/Quality - Paper Options - Custom
0
 

Author Comment

by:keith66miners
Comment Utility
Lee,
On the PC connected directly to the printer:-
In Printing preferences paper quality paper options I have displayed "Cheques" defined via the Print Server Properties.
On other PCs trying to print via the connected PC I have defined "Cheques" defined via the Print Server Properties, but the  Printing preferences paper quality paper options  has no display of it - (only about 12 options). So how do I get the remote PC to have the local's printer setting?
Keith
0
 
LVL 7

Expert Comment

by:Lee Ingalls
Comment Utility
Keith,
I'm guessing the printer is shared from the Windows 7 computer... is the sharing configured to render print jobs on the client computers? Also note just below that the Additional Drivers for use when different versions of Windows are connecting to the printer.

Lee
0
 
LVL 100

Expert Comment

by:mlmcc
Comment Utility
Is the printer driver installed on the machine or are they using the printer driver from the Win 7 box?

You probably have to install the paper/form on each printer driver on the user boxes.

mlmcc
0
 

Author Comment

by:keith66miners
Comment Utility
aikimark
This is a VB6 application.

With regard to the printer drivers I believe I  have 32 and 64 bit  drivers.
The printers have been "add new printer" through windows 7 and this does report that they are "installed" - do I have to update driver from the specific copies I have and then re-edit the Forms available?

I have left for the weekend - will progress Monday
Keith
0
 
LVL 100

Expert Comment

by:mlmcc
Comment Utility
Since you are installing the printer drivers onto each client, yes you will have to add the form to each one.

When you install the driver it uses the default driver which doesn't have your form in it.

mlmcc
0
How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

 

Author Comment

by:keith66miners
Comment Utility
mlmcc
I repeat my comment to Lee (see above) - new forms have been added via the Printer Server Properties on the client boxes - but even then  Printing preferences paper quality paper options  has no display of it - (only about 12 options).

So on the pc (pc A) which is printing via pc B (locally connected via plug and play) the cheque form shows when Printer Server Properties is chosen, but not when  Printing preferences paper quality paper options  is chosen.
 
 So how do I get the client PC to have the local's printer server setting?
Keith
0
 
LVL 100

Expert Comment

by:mlmcc
Comment Utility
Where are you seeing the "Printing preferences paper quality paper options"?

I don't have a viewer or viewing application only Crystal so I don't see that option.

mlmcc
0
 

Author Comment

by:keith66miners
Comment Utility
mlmcc
I'm not doing this via Crystal.
From Start - devices/printers - select printer - right click - printing preferences - advanced - paper size drop down
This list doesn't contain Cheques which is defined via
From Start - devices/printers - select printer - Print Server properties - Forms

Keith
0
 
LVL 100

Expert Comment

by:mlmcc
Comment Utility
For Crystal to use it unless you set it as the default paper, you have to do the selection in the report designer.

I don't know if printer properties like paper size are controlled by permissions but they might be especially in Win 7.

mlmcc
0
 

Author Comment

by:keith66miners
Comment Utility
mlmcc
This application ran successfully on XP - setting the cheque form on the design phase - it's still there on my development system (w 2k).
Only when I try to print the cheques via a windows 7 64 bit does it fail (even though the printer services has the form).
As for permissions each of my users is set up as an Admin user within the application.
I'm being driven mad by this!!!!!

Keith
0
 
LVL 100

Assisted Solution

by:mlmcc
mlmcc earned 100 total points
Comment Utility
I don't think it is permissions in the application but permissions on the Win7 box that has the printer.

I believe the issue is what permissions do you have on the Win7 box and on the printer attached to it.

In making Windows more secure some permissions have been changed.  Can you run the application on the Win7 box?  Do the checks print correctly?

mlmcc
0
 

Accepted Solution

by:
keith66miners earned 0 total points
Comment Utility
It appears as though there is some conflict on the network.
The printer has now been attached to the database server(sql 2008) via a "parallel to usb" connector (removed from windows 7 box).
So the pc's all reference "tallygen on server" rather than "tallygen on windows 7".
Now all PC's show all form lengths on printer properties and the cheques all print correctly formatted.
Thanks for your attension
Keith
0
 

Author Closing Comment

by:keith66miners
Comment Utility
Neither expert suggested the actual solution or any reason why the previous environment (printer attached to W7) wouldn't work.
0

Featured Post

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

When trying to find the cause of a problem in VBA or VB6 it's often valuable to know what procedures were executed prior to the error. You can use the Call Stack for that but it is often inadequate because it may show procedures you aren't intereste…
Background What I'm presenting in this article is the result of 2 conditions in my work area: We have a SQL Server production environment but no development or test environment; andWe have an MS Access front end using tables in SQL Server but we a…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now