We help IT Professionals succeed at work.

Insert several OLE objects based on criteria?

Cree asked
Last Modified: 2012-05-11

Hi, I'm wondering is it possible to insert different OLE objects in the same spot but to have each OLE output based only on certain criteria or attributes?  Do I use some type of suppression formula or is it an "if then else" statement?  I just don't understand how to include OLE objects into a formula.  Thanks a bunch to anyone who can help!
Watch Question

Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

What version of Crystal?

You could easily use suppression to control which of several OLE objects was visible.

CR XI and later allows you to have the filepath as a field in the record and just display based on that.
There is also a formula when you format the OLE to allow you to choose which picture.

I am not sure about earlier versions other than through the suppression idea.



I have XI.  This topic exceeds the scope of the book i purchased for the program.

What I have is a numeric field on form.  0 - 9 .
When the report is run.  I want to set a IF then statement that will pull the ole word doc that corresponds to the number.  Should be simple.  I just don't know how to specify the ole object with correct file path in Formula workshop.
Sr. Business Intelligence Consultant/Architect
This one is on us!
(Get your first solution completely free - no credit card required)
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.


Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.