Need Crystal Formula Help

John,



This is the formula I use to print employee photos on the badge.



"\\VANTAGE\mfgsysdata\EmpPhoto\XXX\" + {EmpBasic.PhotoFile} + ".bmp"



The double quotes are part of the formula.



Hope this helps.



Dale



________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of JohnBob
Sent: Tuesday, November 27, 2007 8:20 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Need Crystal Formula Help



I have confirmed that the formula is probably not the problem. If you
insert an object then format that object, click on the picture tab and
select 'graphic location', the formula editor opens up. If you put in
{drawings.filename}, the object will change as the part number changes
(if you create the following selection criteria... {Drawings.Key1} = {?
Pm-JobAsmbl.PartNum}--- AS LONG AS IT IS AN IMAGE FILE!?!?!?? Is
there perhaps an executable program formula that I could put in there
that would make a .pdf work also? Does anyone have any ideas?

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"JohnBob" <jholden@...> wrote:
>
> I am attempting to insert an OLE object into the job traveler. When
> you format the object, it allows you to get the "graphic location"
> based off of a formula. I have the correct tables and am able to
get
> the menu path to the pdf that corresponds with that part number via
> {drawings.filename}. I cannot figure out however hoe to get the OLE
> object to change to the listed part number on the next job
traveler.
> I have attempted to just write {drawings.filename} and attempted the
> use of Functions>Document Properties>CurrentLocale=
{drawings.filename}
> but nothing I have tried seems to work. Any suggestions?
>




########################################################################
Attention:
This email message is privileged and confidential. If you are not the
intended recipient please delete the message and notify the sender.
Any views or opinions presented are solely those of the author.

This email message has been scanned for Viruses and Content and cleared
by MailMarshal SMTP

For more information go to http://www.ramsys.com
########################################################################


[Non-text portions of this message have been removed]
I am attempting to insert an OLE object into the job traveler. When
you format the object, it allows you to get the "graphic location"
based off of a formula. I have the correct tables and am able to get
the menu path to the pdf that corresponds with that part number via
{drawings.filename}. I cannot figure out however hoe to get the OLE
object to change to the listed part number on the next job traveler.
I have attempted to just write {drawings.filename} and attempted the
use of Functions>Document Properties>CurrentLocale={drawings.filename}
but nothing I have tried seems to work. Any suggestions?
I have confirmed that the formula is probably not the problem. If you
insert an object then format that object, click on the picture tab and
select 'graphic location', the formula editor opens up. If you put in
{drawings.filename}, the object will change as the part number changes
(if you create the following selection criteria... {Drawings.Key1} = {?
Pm-JobAsmbl.PartNum}--- AS LONG AS IT IS AN IMAGE FILE!?!?!?? Is
there perhaps an executable program formula that I could put in there
that would make a .pdf work also? Does anyone have any ideas?


--- In vantage@yahoogroups.com, "JohnBob" <jholden@...> wrote:
>
> I am attempting to insert an OLE object into the job traveler. When
> you format the object, it allows you to get the "graphic location"
> based off of a formula. I have the correct tables and am able to
get
> the menu path to the pdf that corresponds with that part number via
> {drawings.filename}. I cannot figure out however hoe to get the OLE
> object to change to the listed part number on the next job
traveler.
> I have attempted to just write {drawings.filename} and attempted the
> use of Functions>Document Properties>CurrentLocale=
{drawings.filename}
> but nothing I have tried seems to work. Any suggestions?
>