Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

OLE object in CR6

Status
Not open for further replies.

nutcase

Programmer
Jan 11, 2002
22
ZA
I have an OLE object (a logo) inserted into one of my reports. I want to change the logo from Logo_A to Logo_B based on a field in the record coming in. I can't seem find a way to make this happen. I have tried linked and imbedded. I don't want to have to split the data coming in and have two reports. Anyone out there doing this or know how to do this?

[sig][/sig]
 
Can you put both of them on the report, and suppress suppress the one that you don't want to see based on a formula condition that uses the field? I don't think you have direct access to the path property of the OLE object.

[sig]<p>Ken Hamady- href= Reports Training by Ken Hamady</a><br>[/sig]
 
I've about worked this on to death. I can get both OLE Objects on the page, but I can't figure out how to suppress one.

I've got about this far:

if {qfr_G101;1.becode} = 1 then
(I want to Turn off the ahm logo)
else if {qfr_G101;1.becode} = 2
(I want to then turn off the loma logo)

Anyone have any ideas?

Thanks,

Ken (speer@loma.org)
 
OH NEVER MIND!!!!
Searched FAQ for &quot;toggle graphics&quot; and got the answer. Put both graphics on the report on top of one another. On one click &quot;format graphic&quot;, behind &quot;supress&quot; click the &quot;x-2&quot; and enter formula {qfr_G101;1.becode} <> 3

Do the same to the second graphic and enter {qfr_G101;1.becode} <> 2

Well, well, well, even hard headed old men sometimes learn new things.

Ken
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top