asked on
Insert several OLE objects based on criteria?
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!
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!
Crystal Reports
Last Comment
Kurt Reinhardt
ASKER
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.
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.
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
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