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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

In a formula, can you use bitmap files? 2

Status
Not open for further replies.

davidseo

MIS
Dec 14, 2000
3
0
0
US
I am trying to use if else logic to print different bitmaps for logos. Is this possible in crystal?
What version would I need to be on if possible?

Thanks

David
 
No, but you can "stack" several Bitmaps and suppress them based on conditions, which accomplishes the same thing. Ken Hamady
Crystal Reports Training and a
Quick Reference Guide to VB/Crystal
 
Sorry for the lack of brains on my part.
Could you provide more information on how to accomplish this?
How do you assign the bitmaps to variable names?
What would the if else statement look like?

Thank you.
 
Place both objects in the same place, one on top of the other. Then tell each to be invisible based on a certain condition.

Right Click each object and select the format option, and click on the common tab.

Next to Suppress there is a pencil button that opens the formula editor, and you put in a boolean formula to tell it when to suppress.

Use opposite formulas for each object.

one could be
{Company} = "A"

and the other would be
{Company} <> &quot;A&quot;


The one that has a True for that record will be suppressed. Ken Hamady
Crystal Reports Training and a
Quick Reference Guide to VB/Crystal
 
This works very nicely. Thank you very much.

David
 
You can display pictures without overlaying items as mentioned above IF you create a BLOB field or if you use Access an OLE object field to associate with your different rows. The Bitmap/JPG or other recognizable format for CR has to be stored in the database. Otherwise, you will have to revert to the overlaying option.

To fully understand this option, using MS Access, create a table containing 2 fields, one for your key and another as an OLE Object. Click on the view button in the upper left hand corner (or from the menu select View, datasheet view). You will have to right click on the OLE Object field and select &quot;Insert Object&quot; to add the picture. Do this for a couple of records, then go to Crystal Reports and create a report using that database and table and display the picture field in the detail section and you will see the picture. One other note. In crystal, after dragging and droping the picture into the detail section, right click and select &quot;Format Graphic&quot;. The &quot;Can Grow&quot; item needs to be marked for Crystal to automatically adjust for the size of the picture. Hope this is helpful also.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top