Crystal Reports Multi-Part Identifier Could Not Be Bound When Adding a Field

Hello:

Attached is a Crystal Report that was working.  It's not working, now.

I modified the report to contain the SY01200 table, so that we can pull the INET5 field into the report.  With the table added, the report still generates without error.

And, as long as I run the report without the INET5 field, it generates fine.  

But, if I have the field INET5 on the report or in an if-then statement (as it is now for the @ShipToAddress formula), I get the attached error stating that the multi-part identifier could not be bound.

How do I get rid of this error?

Thanks!

TBSupport
Invoice.rpt
MultiPart-Identifier-Could-Not-B.docx
LVL 1
TBSupportAsked:
Who is Participating?
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.

vastoCommented:
Did you verify the report ?
0
mlmccCommented:
Have you tried a VERIFY DATABASE to ensure you have the latest table structures?

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
TBSupportAuthor Commented:
Yes, I did.  Please tell me what else I can check.

TBSupport
0
Exploring SQL Server 2016: Fundamentals

Learn the fundamentals of Microsoft SQL Server, a relational database management system that stores and retrieves data when requested by other software applications.

mlmccCommented:
Can you add the INET5 field and show the SQL it generates?

mlmcc
0
TBSupportAuthor Commented:
Hi mlmcc:

The answer was to do a Database ->Show SQL Query, and hit the RESET button.   Evidently, the report had not been upgraded.  So, the postings here were "on the right track".

Thanks!

TBSupport
0
mlmccCommented:
vasto suggested the verify database before I did and as such deserves credit for that suggestion.

Perhaps it should be a split between his comment and my comment on showing the SQL

mlmcc
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
Crystal Reports

From novice to tech pro — start learning today.