Generate dynamic image based on If Condtion

Question

Hi guys How do i generate dynamic image based on IF condtion in crystalreport using visual studio 2008 for example I want to display (ok.ICO) image if profit exceeds 20 other wise display (attention.ICO) image

Manikavelu Velayutham · Answer

You can find few sample code to render as pdf in this below link. http://social.msdn.microsoft.com/Forums/en-US/vsreportcontrols/thread/12b56c3f-fa41-4a27-a0dd-faf9b27d2b5a

dina · Answer

Thank you very much

dina · Answer

Ok everything goes well (Microsoft Reporting) except when export report into PDF format it doesn't shows all columns in one row but few last columns shifted to the next page though I tried many times to adjust column width to the minimum in report designer  reportviewer shows the report properly but when export it to pdf it is completly different from reportviewer what am i doing wrong or is this disadvantage that microsoft is responsible ? Thanks in advance.

Manikavelu Velayutham · Answer

yes you can also have the images in the folder. Have the filename condition and its location in database. Based on the matched condition retrieve the exact file from that folder. You can achieve your goal by this way also.

dina · Answer

Thanks for your reply I tried out your solution and works fine but I don't want to save images in sql server but in filesystem that's why I 've adopted (visual studio reporting) and i found out that solution is much more easy than that in crystal report but unfortunatly when I'm trying to export the file in (visual studio reporting) into PDF format the columns is not displayed completly along the page width but but some columns are shifted to the next row though I set up the font and narrow the columns width as much as possible changes reflects on the report viewer in web page but not in PDF file Is there any suggestions ? Best Regards.

Manikavelu Velayutham · Answer

Store all the images as stream of bytes in database using BLOB datatype. Add one more column to that table which will have the conditions like Profit > 20 or Profit Based on the values selected display the image from the database