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

Brett Atkinson
Brett Atkinson used Ask the Experts™
on
I had this question after viewing BLOB IN CRYSTAL REPORTS 10 - IF NO IMAGE IN DB - HOW TO PRINT NO IMAGE AVAILABLE.

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?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
View Solution Only
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
Are the blobs in the same table?

mlmcc
Brett Atkinson

Author

Commented:
No, the blobs are in a separate table ( ITEMPIC.ImageBMP).
Senior Consultant
Most Valuable Expert 2011
Top Expert 2013
Commented:
Did you join the blob table with a LEFT OUTER JOIN?

Are you filtering based on the BLOB table?

mlmcc
Brett Atkinson

Author

Commented:
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!!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial