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

TBSupport
TBSupport used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2011

Commented:
Did you verify the report ?
Senior Consultant
Most Valuable Expert 2011
Top Expert 2013
Commented:
Have you tried a VERIFY DATABASE to ensure you have the latest table structures?

mlmcc

Author

Commented:
Yes, I did.  Please tell me what else I can check.

TBSupport
Learn SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

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

mlmcc

Author

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
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

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

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