Solved

Sizing an OLE object in Crystal Reports 10

Posted on 2008-10-31
9
1,697 Views
Last Modified: 2013-12-11
I am trying to link an advertising flyer into a MAS 90 Crystal Reports invoice form.  I have tried inserting a jpeg image using Insert, Picture and I've tried inserting a PDF file as an OLE object.  In both scenarios, Crystal in scaling the image down to about 75% of its original size when I actually insert the link or picture.  This creates distortion, especially on the text of the pdf or jpeg.  Is there a way to specify the size of the inserted picture or OLE object in the process of inserting it?  
0
Comment
Question by:davidfretz
  • 5
  • 4
9 Comments
 
LVL 16

Expert Comment

by:wykabryan
ID: 22850403
I dont suppose you can attach the image can you??
0
 

Author Comment

by:davidfretz
ID: 22850535
Here is the PDF file that I was orginally trying to link to.  
Hinge-Flyer.pdf
0
 
LVL 16

Expert Comment

by:wykabryan
ID: 22850554
Where are you trying to insert the pdf at?? In the page footer, or report footer... or some place else.
0
 

Author Comment

by:davidfretz
ID: 22850642
In the report header, so when they open the invoice it displays as the first page.  Some more background-the accounting software sends an email that includes as an attachment a PDF copy of the invoice to a customer after a purchase.  We want to use the opportunity to send some sort of advertising along with the invoice.  We cannot change the email itself from a simple text-based email, and we can't include any other attachments, so our only option is to edit the invoice itself to include the advertisment, and the invoice is a Crystal form.  So far the only solution I could come up with in Crystal is to somehow insert or link the ad.  But if there's a better way to accomplish in Crystal what I'm talking about, I'm open to that as well.
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.

 
LVL 16

Expert Comment

by:wykabryan
ID: 22850683
So if you put this into the report footer it will appear a little smaller. Right click and format graphic. Then go to the picture tab and change scaling to 125% or size to 8 by 11. Now you have to have your margins set up to handle this size. Next, you will want to suppress the headers and footers. Suppress everything that is not needed on the last page by going into the Section expert and clicking on the X+2 button next to the suppress. Then type in OnLastRecord.  This way after the last record everything else will be suppressed. Hopefully this gets you down the right path.
0
 

Author Comment

by:davidfretz
ID: 22850867
I tried the resizing bit, and it does make the pdf the correct size, but the funny thing I can't seem to get around is the image distortion still occurs.  Because the PDF gets sampled down, and then enlarged, the quality suffers.  It appears that for some reason Crystal just doesn't render this correctly, and I assumed because it was scaling it down to begin with.  The funny thing is, even when I use a different pdf ad that is 4 by 5 to begin with, it still scales it down to 75% on insert and which again destroys the image quality.  Is there a way to create a box for the object before inserting it?
0
 
LVL 16

Accepted Solution

by:
wykabryan earned 500 total points
ID: 22850922
Unfortunately when it comes in it is compressed to a size of 6 x8. So you are right by expanding the picture, it does distort. There isnt a way around that unless you make the image bigger that the 8x11. I would say if you went to the 11x18 paper size and then tried to import it in it may compress it to the right size and good quality. Crystal does not use vectoring on images.

Border.. yes.. right click on the image. Format Graphic. Border tab.
0
 

Author Closing Comment

by:davidfretz
ID: 31512075
Thanks so much for your help.  It seemed like that was the direction I was headed, but I'm not an in-depth expert on Crystal and wanted to make sure I wasn't missing anything.
0
 

Author Comment

by:davidfretz
ID: 22850986
In my experimentation, it seemed like a high resolution, larger jpeg file came through at an acceptable quality level.  So I'll probably head down that road.
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

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
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 …
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

867 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

17 Experts available now in Live!

Get 1:1 Help Now