Using BLOB fields as page header logos

[jc717]

Hi,

How can I use the BLOB field from 1 record as a logo on all the page headers in the report.
I know that one solution would be to copy the logo into every record, but that wastes too much space.
Is there a way to tell crystal to just use the BLOB from X record for all the page headers?

Thanks,

JC

 

[KellyStee]

One simple answer would be using a subreport. Have you tried that?

Kelly
kelly.steensma@us.pwcglobal.com

 

[jc717]

How would I go about doing that?

I just need to have 2 different logos on each report. The users will need to be able to choose the logo at run time.

Do you mean the the logos should be sub-reports?


Thanks,

JC

 

[KellyStee]

Question: Do the logos comes from two different records? I think they would still have to be a subreport.
In the subreport:
place both logos in the report stacked on top of each other. Then enter a suppression formula and a parameter. The suppression formula would be something like this:
If {?Logo Type} = "Flying Elephants" then Flying_Pigs
Else Flying_Elephants

The formula would suppress which ever logo the client didn't want.
Let me know if you still have questions.

Kelly
kelly.steensma@us.pwcglobal.com

 

[jc717]

The thing is that there are a lot of logo possibilities, and the end users should have the option of chosing their own file to act as a logo.

I can add 2 fields to the recordset, 1 for each logo.

I can programatically populate those fields. I run into resource problems if I populate all the records with the BLOBs. I'm wondering if there's a way to tell crystal to only use the BLOBs from record #X for all the page headers.

The workaround I have right now is that I link 2 image files into the report instead of embedding them. I then programatically rename the pictures that I want to correspond to the file names linked to the report.
This works, but I noticed that it takes a while to 'link' OLE objects. BLOBs would yield better performance.

I hope that this explains my situation in more deatail.
Let me know if you have any ideas.

Again, thanks very much for your time.

JC

 

[KellyStee]

What if you set up a separate table for the BLOBS. You could then have a subreport that accessed this separate table. Based on the results of a parameter, the subreport would pull in the right client logo.

Kelly

 

[jc717]

That will work, thanks very much.

JC

 

[dean12]

How do I go about getting the logo into a SQL 2000 database? I've only got say 1 or 2 images so I hate to sit down and try to learn enough VB interfacing to load it that way - is there a form of INSERT statement or a utility program?

 

[dean12]

I did find finally information on how to load an IMAGE into a SQL 2000 database without resorting to program development which I cannot do in this instance. See this page:

http://www.swynk.com/friends/achigrik/Textcopy.asp