We help IT Professionals succeed at work.

Insert several OLE objects based on criteria?

Cree
Cree asked
on
862 Views
Last Modified: 2012-05-11
Hi,

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!
Comment
Watch Question

Mike McCrackenSenior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013

Commented:
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.

mlmcc

Author

Commented:
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
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
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.

OR

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.