Solved

Sizing an OLE object in Crystal Reports 10

Posted on 2008-10-31
9
1,812 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
[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
  • 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
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: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

Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

Question has a verified solution.

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

A frequent question here in the MAS90 Zone is, How do you get data out of MAS90 for analysis, reporting or using the data on your web pages?   This is an introductory level tutorial to getting data out of MAS90 using ODBC. Data can be accessed by…
Hi, I've just fixed a problem with Sage 50 Accounts 2011 crashing when creating a new Company.  I've wasted several hours on it so I thought I'd share the solution with others.  Remarkably, the same laptop had what appears to be exactly the same …
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

707 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