Solved

crystal reports XI on windows 7 from XP

Posted on 2014-02-21
16
500 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
ID: 39876917
This might be related to the printer , not the report
0
 
LVL 7

Assisted Solution

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

Author Comment

by:keith66miners
ID: 39877084
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
ID: 39877185
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
ID: 39877269
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
ID: 39877438
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
ID: 39877691
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
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 

Author Comment

by:keith66miners
ID: 39879111
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
ID: 39879318
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
ID: 39885165
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
ID: 39885685
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
ID: 39885943
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
ID: 39886305
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
ID: 39906305
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
ID: 39917003
Neither expert suggested the actual solution or any reason why the previous environment (printer attached to W7) wouldn't work.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

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…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

932 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

12 Experts available now in Live!

Get 1:1 Help Now