Crystal Reports (add a picture from formula)

Yahoo Archive
1
Aaron,

There is a non-programmatic means to do exactly what you are trying to
accomplish. First, create an Access database with two fields: the image and
the linking key (employee ID in your example) then populate the database.
See the following link for all of the details:

http://support.crystaldecisions.com/communityCS/TechnicalPapers/cr_insert_im
ages.pdf

While Crystal doesn't support linking multiple data sources in any version
prior to 9, you can insert the image in a linked subreport. Here's the
details:

http://support.crystaldecisions.com/communityCS/TechnicalPapers/scr_subrepor
ts.pdf

Finally, here's a brief description of this workaround and why it works:

http://support.crystaldecisions.com/kbase/c2008838.asp

Good luck.

Michael

Michael Barry
Aspacia Systems Inc
866.566.9600
312.803.0730 fax
http://www.aspacia.com/


-----Original Message-----
From: Aaron Hoyt [mailto:aaron.hoyt@...]
Sent: Thursday, July 31, 2003 1:30 PM
To: 'Vantage E-Group (E-mail) ' (E-mail)
Subject: [Vantage] Crystal Reports (add a picture from formula)


Anyone out there that can give me an idea if you can and how to insert a
picture in crystal via a formula. For instance, I am trying to come up with
a report similar to the Employee badge in Report Builder, that has the
picture included, but can't seem to find how to do it in crystal...
That is, short of adding all the pictures on top of each other and then
conditional printing each of them...more than a little silly for my desired
task.

Thank you for any responses.

Aaron Hoyt
Design Standards


Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
2
Anyone out there that can give me an idea if you can and how to insert a
picture in crystal via a formula. For instance, I am trying to come up with
a report similar to the Employee badge in Report Builder, that has the
picture included, but can't seem to find how to do it in crystal...
That is, short of adding all the pictures on top of each other and then
conditional printing each of them...more than a little silly for my desired
task.

Thank you for any responses.

Aaron Hoyt
Design Standards
3
Aaron,

I'd been down that path once before and I believe there is no simple way
to do it without using the Crystal developer tools. If the image files
are actually stored in the database (unlike Vantage employee photos), it
is possible but I think that having just the path to the image like
Vantage does is a no go. In the end, I ended up just setting up my
employee badges to print out of Access. Then after a while we got sick
of the images anyway and went back to Crystal ;).

Adam Ellis
SaberLogic, LLC

On Thu, 2003-07-31 at 16:29, Aaron Hoyt wrote:

> Anyone out there that can give me an idea if you can and how to insert a
> picture in crystal via a formula. For instance, I am trying to come up with
> a report similar to the Employee badge in Report Builder, that has the
> picture included, but can't seem to find how to do it in crystal...
> That is, short of adding all the pictures on top of each other and then
> conditional printing each of them...more than a little silly for my desired
> task.
>
> Thank you for any responses.
>
> Aaron Hoyt
> Design Standards
>




[Non-text portions of this message have been removed]