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

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?
Brett AtkinsonAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mlmccCommented:
Are the blobs in the same table?

mlmcc
0
Brett AtkinsonAuthor Commented:
No, the blobs are in a separate table ( ITEMPIC.ImageBMP).
0
mlmccCommented:
Did you join the blob table with a LEFT OUTER JOIN?

Are you filtering based on the BLOB table?

mlmcc
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Brett AtkinsonAuthor 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!!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
blob

From novice to tech pro — start learning today.