<div>
I will assume that your table contains the following info:<br />
<br />
TABLE<br />
ID &nbsp; &nbsp; GENDER &nbsp; &nbsp;BLOB/IMAGE<br />
1 &nbsp; &nbsp; &nbsp;Female &nbsp; &nbsp; girl<br />
2 &nbsp; &nbsp; &nbsp;Male &nbsp; &nbsp; &nbsp; &nbsp; boy<br />
<br />
//Your New Formula Field (@ShowPicture)<br />
if {TABLE.Gender} = &quot;Male&quot; then<br />
&nbsp; &nbsp;{Table.boy}<br />
else if {TABLE.Gender} =&quot;Female&quot;<br />
&nbsp; &nbsp;{Table.girl}<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />

</div>


I will assume that your table contains the following info:

TABLE
ID     GENDER    BLOB/IMAGE
1      Female     girl
2      Male         boy

//Your New Formula Field (@ShowPicture)
if {TABLE.Gender} = "Male" then
   {Table.boy}
else if {TABLE.Gender} ="Female"
   {Table.girl}









<div>
Thanks a lot !<br />
<br />
it's worked !
</div>


<div>
Thanks.<br />
Glad I could help.
</div>


<div>
<div class="content wysiwyg-content">
hi all,<br />
<br />
i have a question about dynamic photo showed in Crystal report 9 prof,<br />
<br />
in my case,<br />
i am using CR9's database expert to connect to sybase directly without any VB or VB.code<br />
and<br />
i want to show a boy photo when get a value from database is &quot;Male&quot;,<br />
if get a &quot;Female&quot; value then show a girl photo.<br />
<br />
for example<br />
if TABLE.Gender = &quot;Male&quot;<br />
SHOW &nbsp;boy picture<br />
else if TABLE.Gender =&quot;Female&quot;<br />
SHOW girl picture<br />
<br />
should i use the formula to fulfill this task <br />
and how to do that ?<br />
<br />
thanks <br />
<br />
tony
</div>
</div>


hi all,

i have a question about dynamic photo showed in Crystal report 9 prof,

in my case,
i am using CR9's database expert to connect to sybase directly without any VB or VB.code
and
i want to show a boy photo when get a value from database is "Male",
if get a "Female" value then show a girl photo.

for example
if TABLE.Gender = "Male"
SHOW  boy picture
else if TABLE.Gender ="Female"
SHOW girl picture

should i use the formula to fulfill this task 
and how to do that ?

thanks 

tony

Question about dynamic photo showed in Crystal report 9 prof

Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.