Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Crystal .NET viewer printing - paper size/orientation issues

Posted on 2014-01-17
11
Medium Priority
?
3,046 Views
Last Modified: 2014-02-10
We are currently working with Crystal XI and distributing reports through a 3rd party distribution tool that utilizes the Crystal Active X viewers.  We are in the process of migrating to Crystal 2011 which uses .NET viewers (not active x).  In our reports I have the "No Printer" option checked in the report's design.  In Crystal Active X viewer, when a report is run and you click the print button in the viewer, you can see in the attached on slide 1 that it is picking up the Page set up in the report's design and passing to printer.  Legal/landscape/Actual size.  When I run this same report through the .NET viewers it defaults to Letter/Portrait and for extra fun, Fit to Page.  Ideally we'd like the .NET viewer to do the same as active X and know by the report's design what the paper size/orientation needs to be.

In slide 2, it would ideally have Actual size marked as default, auto portrait/landscape is fine (but I had to select it the first time and then it stuck), and then it already have the correct paper size (legal) selected when you click Advanced to see those options.

The default printer in the report is on the server running the app, so that is not the cause.  All variables are in place on our new Crystal 2011 environment that are on our current Crystal XI.

Please tell me this is fixable!  I have looked for solutions to this every where, including a similar post here, and have yet to see a solution.  If we have to tell users that they now need to select their paper size and check off Actual this will be seen as extra step and not an improvement incentive to move to a new platform.
CrystalNETprinting.ppt
0
Comment
Question by:melandcurt
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 7
  • 4
11 Comments
 
LVL 101

Expert Comment

by:mlmcc
ID: 39791309
CR 2011 does NOT include an SDK and is NOT intended for use in applications.

You should be using the version that is available for Visual Studio.  If not included with your VS, it is a free download.

What version of VS are you using?

The .Net viewer is different from the AciveX viewer and may not support the features you are trying to use.

mlmcc
0
 

Author Comment

by:melandcurt
ID: 39792410
We are not using VS. We design the reports in the Crystal Reports 2011 designer and then publish them in a 3rd party report distribution tool that uses the crystal . NET runtime viewers.
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 39792975
You probably need to discuss this with the vendor of your 3rd-party tool.

Which 3rd-party tool?
Does it support CR 2011?
Perhaps you need an upgrade from them.

mlmcc
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:melandcurt
ID: 39794091
It is not the 3rd Party tool.  Yes, they support .NET and crystal 2011.  We are on their latest version.  They only use the crystal viewers for report display and printing, nothing more.  If you look at my attached screen shots it is the functionality within the crystal viewer that has changed. From everything I have read it is more than likely the .NET viewers for this version of crystal.  I have read that they tend to take on the properties of the printer defaults as opposed to the report design page setups like the Active X viewers do.  I have done a lot of "homework" on this matter and was hoping someone here has found something to work around this or a solid solution, but it does not appear to be the case.  I don't feel like I'm getting much further here b/c I think this is just how it works. Which would be a major set back for Crystal b/c currently the users click a printer button inthe viewer and it knows what paper size and orientation to print and now they will have to select these things. Also the default to Fit to Page instead of Actual size is a big inconvenience.
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 39794178
Crystal does save the printer information but it is saved for the printer the report was built with.  If that printer is not available then the default printer is used and the defaults for that printer are used.

I believe if you install the printer driver the users have on the development machine then you can open the report, change the printer, and save the report.  It should run as you desire.

mlmcc
0
 

Author Comment

by:melandcurt
ID: 39794216
We have users in many different states that would not be printing to the printer the report is designed with.  All of the print drivers and printers that are on the server with the Crystal XI version are on the Crystal 2011 version.  The reports have the No Printer option selected in both versions but has the paper size and orientation set.  The active X viewer accepts this and no matter what printer is selected it knows the report's design.  .NET printers do not seem to care about this.  Currently I am the only one using this version as we have not deployed it yet.  The default printer on my machine is on the server running the Crystal 2011 and this does not change the outcome even when I save that printer in the report's design.  
The other recommendations I have seen is to change the default printer settings to be the paper size and orientation (in this case legal) you wish is to be and then it will work, but I have my doubts about this as well b/c like I said we have users in different offices and states that will print to their default printers, not the one the report is designed with.  I will be trying this today however to see if it works.
0
 
LVL 101

Expert Comment

by:mlmcc
ID: 39794391
CR2008 changed the printer interface.  I think CR2011 has the same options.

There is a new option to DISSOCIATE FORMATTING PAGE SIZE AND PRINTER PAPER SIZE.

Try clicking that then setting the paper size.

The NO PRINTER option was used to optimize the report for screen display.

mlmcc
0
 

Author Comment

by:melandcurt
ID: 39794517
Have already tried various combinations of this as well.  Having a printer and checking the Dissociate option.  Having No printer and Dissociate.  Same outcome.  I am having my IT guy verify that the print drivers on this server are in fact the same as our current production server, but I believe they already are.
0
 

Assisted Solution

by:melandcurt
melandcurt earned 0 total points
ID: 39800613
I believe we have the solution to this after logging a call with SAP directly.  The .NET Crystal viewers by default come out of the box with a print mode property of pdf.  This option is what is giving the undesired results.  The solution is to change this print mode property to ActiveX which will then use the Active X print options.  I will attach screen shots of the solution.
0
 

Accepted Solution

by:
melandcurt earned 0 total points
ID: 39833920
So my last comment was accurate and our software vendor for our 3rd party reporting tool has a Print mode option which makes the Active X print control work. After switching this on we were getting "a Communication error has occurred.  Printing will be stopped".  Then I stumbled across a report that the print control worked.  Baffled, I did more digging and came up with a lady that had an issue where her report parameters were buggy and sending extra values to the query which threw an error.  Ding ding! The report that worked has NO parameters to fill in. So I tested a few more reports without parameters and all the the Print Controls worked.  So the software vendor is now looking into if there are extra parameters being thrown in code in the background.  Will keep posted.
0
 

Author Closing Comment

by:melandcurt
ID: 39846814
The suggestions given by the expert were all that I had come across with research online prior to me opening the call here.  Also they stopped responding after their 4th comment.  I logged a call with SAP and got the correct answer.  Also worked with out 3rd party vendor as some of the capability was within the product, but there were a few bugs.
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

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

Healthcare organizations in the United States must adhere to the guidance of both the HIPAA (Health Insurance Portability and Accountability Act) and HITECH (Health Information Technology for Economic and Clinical Health Act) for securing and protec…
Curious about the latest ransomware attack? Check out our timeline of events surrounding the spread of this new virus along with tips on how to mitigate the damage.
The viewer will learn how to create multiple layers to apply various filters and how to delete areas from each layer’s filter.
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…

721 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