• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1965
  • Last Modified:

Sizing an OLE object in Crystal Reports 10

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
davidfretz
Asked:
davidfretz
  • 5
  • 4
1 Solution
 
wykabryanCommented:
I dont suppose you can attach the image can you??
0
 
davidfretzAuthor Commented:
Here is the PDF file that I was orginally trying to link to.  
Hinge-Flyer.pdf
0
 
wykabryanCommented:
Where are you trying to insert the pdf at?? In the page footer, or report footer... or some place else.
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
davidfretzAuthor Commented:
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
 
wykabryanCommented:
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
 
davidfretzAuthor Commented:
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
 
wykabryanCommented:
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
 
davidfretzAuthor Commented:
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
 
davidfretzAuthor Commented:
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

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

  • 5
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now