Print Page | Close Window

"this column prefix...does not match

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=11511
Printed Date: 02 May 2025 at 2:11pm


Topic: "this column prefix...does not match
Posted By: zkeepitrealz
Subject: "this column prefix...does not match
Date Posted: 25 Oct 2010 at 6:57am

After adding a new table to an existing report, linking correctly, and adding 2 columns from the tbl to the report, I get "this column prefix (tbl name) does not match with a table name or alias name used in query". Table was added correctly in DB Expert, but when i go to Show Sequel Query, the table and key column does not show, either. Looks like the link is ok and the DB Expert shows it and the key column. Pls Help Thanks!

Using crystal XI
 


Print Page | Close Window