Solved

Sizing an OLE object in Crystal Reports 10

Posted on 2008-10-31
9
1,791 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
Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

 

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
 
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

Independent Software Vendors: 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!

Question has a verified solution.

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

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

726 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