Question Re: Load logo in Technology Q&A

Load logo

Former Member — Tue, 02 Mar 2010 10:27:45 GMT

Good morning

My idea is try to load a company logo according to the value from a field. (from a path)

it would be like:

If uppercase({?Site})='CIA1' THEN load or insert or xxxxx image from c:\logocia1.xxx (bmp or jpg) else

If uppercase({?Site})='CIA2' THEN load or insert or xxxxx image from c:\logocia2.xxx (bmp or jpg).......

This is in order to avoid to load the 4-6 logos in the same report showing the correct one and deleting the rest. or creating the same report for all the cias...

Could any of you point me how to do it ? i have found a lot of info about loading pictures dinamically or pictures saved on the DB, but nothing about loading the pictures from a path..

Thks & B. Regards

Jose Marin

Re: Load logo

Former Member — Tue, 02 Mar 2010 14:04:14 GMT

Jose, failing a better answer, you could create multiple page headers, each with there own logo, then supress the ones you do not want to see. Not a great solution, but that may be easier in the longrun.

Re: Load logo

Former Member — Tue, 02 Mar 2010 14:35:48 GMT

Good afternoon V361-V361,

Thks for your reply, this is similar to what i already have..

In my case, i have all the logos just in one header and supress it if ?site <> 'CIA1' OR ......., but the issue is that i have to insert all the logos, this is the report is over 3.5 MB each...

In any case. THKS.

B. Regards

Jose Marin

Re: Load logo

Former Member — Tue, 02 Mar 2010 15:33:57 GMT

Thanks for the reply, I had assumed you were already doing that. 3.5 meg huh...well, that would get old in a hurry.

Do you have CRXI ? or some other release?

Re: Load logo

Former Member — Tue, 02 Mar 2010 15:38:00 GMT

Jose, if you have CRXI, look at the sample reports. General Business, Employee Profile.

I notice they have some Blobs of the "Employees" Pictures, perhaps you could do something like that ?

Re: Load logo

Former Member — Tue, 02 Mar 2010 15:46:12 GMT

Jose,

There is no need to load any of the logos into the report. The easy way is to link the report to a shared drive containing the photos.

1) Create a parameter that has a list of the pics in the folder

2) Insert one pic into the report as a place holder image.

3) Right click the pic and choose Format Graphic...

4) On the Picture tab, click the x-2 button next to Graphic Location

5) Write a formula like this:


"C:\Documents and Settings\UserNeme\Image Folder\" & {?Picture Name Parameter} & ".jpg"

HTH,

Jason

Re: Load logo

Former Member — Tue, 02 Mar 2010 16:10:08 GMT

V361,

Thks for your interes in this issue.

Re: Load logo

Former Member — Tue, 02 Mar 2010 16:11:10 GMT

Jason,

Thks, with a modification this solve my issue.

Thks & B. Regards

Jose Marin