Solved

Sizing an OLE object in Crystal Reports 10

Posted on 2008-10-31
9
1,669 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
Comment Utility
I dont suppose you can attach the image can you??
0
 

Author Comment

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

Expert Comment

by:wykabryan
Comment Utility
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
Comment Utility
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
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 
LVL 16

Expert Comment

by:wykabryan
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
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 …
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

744 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