<div>
Are the blobs in the same table?<br />
<br />
mlmcc
</div>


<div>
No, the blobs are in a separate table ( ITEMPIC.ImageBMP).
</div>


No, the blobs are in a separate table ( ITEMPIC.ImageBMP).

<div>
That was the problem. &nbsp;I'm not a Crystal Expert and didn't realize the importance of using &quot;Left Outer Join&quot;. &nbsp;Thank you for your help!!
</div>


That was the problem.  I'm not a Crystal Expert and didn't realize the importance of using "Left Outer Join".  Thank you for your help!!

<div>
<div class="content wysiwyg-content">
I had this question after viewing <a href="https://www.experts-exchange.com/questions/21687359/BLOB-IN-CRYSTAL-REPORTS-10-IF-NO-IMAGE-IN-DB-HOW-TO-PRINT-NO-IMAGE-AVAILABLE.html" rel="ugc">BLOB IN CRYSTAL REPORTS 10 - IF NO IMAGE IN DB - HOW TO PRINT NO IMAGE AVAILABLE</a>.<br />
<br />
I am having the exact same issue. &nbsp;I'm dropping an image directly from our database into my crystal report creating a blob. As soon as I do that any item in the database that doesn't have an image is removed from the report. &nbsp;I have tried every type of isnull statement I can think of and nothing works. &nbsp;The only way I see the entire database is to remove the blob completely. &nbsp;It appears the post I referenced never was resolved. Does anyone have any ideas?
</div>
</div>


I had this question after viewing BLOB IN CRYSTAL REPORTS 10 - IF NO IMAGE IN DB - HOW TO PRINT NO IMAGE AVAILABLE (https://www.experts-exchange.com/questions/21687359/BLOB-IN-CRYSTAL-REPORTS-10-IF-NO-IMAGE-IN-DB-HOW-TO-PRINT-NO-IMAGE-AVAILABLE.html).

I am having the exact same issue.  I'm dropping an image directly from our database into my crystal report creating a blob. As soon as I do that any item in the database that doesn't have an image is removed from the report.  I have tried every type of isnull statement I can think of and nothing works.  The only way I see the entire database is to remove the blob completely.  It appears the post I referenced never was resolved. Does anyone have any ideas?

Adding blob field removes any item that doesn't have image in database - see post referenced below

blob

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.