Cannot remove a table name from the select statement

[leenabhanot]

I used an existing report to create a new one. I removed three tables and added another one. Then I changed the grouping in the report to group using the fields in the new report. The problem is that the 2 tables I removed still show up in the Order by clause of the SQL. I tried stripping those tables from the SQL manually and then adding the new fields to the order by clause but I get a blank report. This is expected because I have no data in the new table but I don't understand why I can't get stuff I have in the report footer and header.
In other reports too I have noticed that when I add fields or tables etc and then perform a grouping based on fields in the new table, the sql does not get updated. I have tried logging off and on to the server with no difference. I am using Crystal 8
Any help would be appreciated.

 

[kenhamady]

How did you remove the tables and add the tables?
What are the group/sort fields currently in the report?
What happens when you view the query and hit the "reset" button. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)