Unable to find 'Conditional picture expert' option in Crystal 2011

[former_member223477]

Hi,

I am developing one report like Product wise Sales report in Crystal Report 2011 Version 14.0.2.364RTM. Here I am grouping the product code and product name and inserting the image for every product , but here I am unable find the "Conditional picture expert" option when I right click on the image in Crystal Report.

Could you please suggest me is it there any other option to do like that.

With Regards,

Krishna

[abhilash_kumar · Accepted solution]

Hi Krishna,

There is nothing called 'Conditional Picture Expert' in Crystal Reports.

If you wish to dynamically display pictures, here's what you need to do:

1) Make sure you have a directory of images either on your shared or local drive (E.g. "C:\Images\")

2) Go to Insert > OLE Object > select Bitmap Image or Paintbrush Picture

3) Right-click the image and select Format Graphic > Picture tab > Click on the Formula button (X-2) beside 'Graphic Location' and put in a formula that reads image locations from the directory.

For e.g. if your Product Name is 'Xbox 360' and you have an image with the name 'Xbox 360.jpg' stored in "C:\Images\", then the formula would be:

"C:\Images\"&{Product_Name}&".jpg"

Hope this helps!

-Abhilash

[former_member223477 · Accepted solution]

Hi Abhilash,

Thanks for your Reply, Here I am giving the condition like below

if {MATERIAL_CODE}='0000010016' then D:\MCFL\Images\pic-mangala-biogold.jpg

But its showing the following error

"A number, currency amount,boolen,date,time, date-time, or string is expected here",

Could you please suggest me how can I write the condition. 

[former_member223477 · Accepted solution]

Hi Abilash,

Thanks for your suggestion.

Its resolved I had given like "

if {ZBAPI_DC_LEDGER.T_IT_FINAL.KUNNR}='0000010000' then 'D:\MCFL\Images\pic-mangala-biogold.jpg'

else if {ZBAPI_DC_LEDGER.T_IT_FINAL.KUNNR}='0000010001' then 'D:\MCFL\Images\pic-mangala-calmax.jpg'" then its parsing OK.

[abhilash_kumar · Accepted solution]

Hi Krishna,

Glad it works! Could you please mark the post as 'Answered'.

-Abhilash

[former_member223477 · Accepted solution]

'Answered'