Data from MsSQL to Crystal Report

[osl]

Hi there!

I am facing this problem when creating a report to display data of an image data type from table in MsSQL database.

The problem is, how do I suppress it in the report if the data is null. It displays as 'X' icon instead of blank. If there is value (binary) in the data then the data is well displayed.

I tried to set a default value to this field in MsSQL but have no idea of what to put to get a blank display.

Attached is the screen capture of the report.

Please help me.

Thank you.

 

[lingsn]

May be can try this, right-click on the image, and select format from the pop-up windows, under the supress formula, check for whether the value is null or not

ISNULL({Table.Picture1})

 

[osl]

lingsn,
At the Format Formula Editor these fields are not visible under the table but at Crystal Report's Field Explorer they are.

Attached are the screens for your reference.

Thank you.

osl

 

[lingsn]

In your Doc2.doc's second image, right-click on the field under the Details (Section 3) to bring out the pop-up menu, and click on the format, then put the formula in the suppress button.

 

[osl]

That's what I did. If you see the screen in attached Doc2, some fields ticked red on screen of the same table are not visible in screen of Doc1. So, how to edit it?