Select statement problem

[WarrenTheWindmill]

I have a problem with my Select statement. If I remove a field from my report it does not remove it from the Select statement. I seem to able to add and remove any other field but this one.

I joined two tables in error when I created the report. I want to remove the join and the offending field. I can remove the join, but not the field. I can't live with this problem because incorrect data is returned to the report.

I am definitely not using the field anywhere else in the report.

I know that CR controls addition and deletion of fields from the Select part of a query, and that you cannot directly change the Select.

has anyone any experience of this? (I am using CR8.5)

Thanks in advance

Dave

 

[Klutch]

First, make sure that the field to be removed is not being used in any formula. After you are sure of that and that does not solve the problem, click "Database" and then click "Show SQL Query". If you are not familiar with SQL, you might want to get somebody to help you who is. But you should be able to remove the join in the "Where" clause and remove the field from the "Select" statement.

I hope this helps.

 

[WarrenTheWindmill]

The answer was in the first line. Although I said I was sure I hadn't used the offending field in any formula, I found it when I started to strip out everything, section by section, from the report.

I had used it to conditionally suppress a section.

Once I removed this, the problem was solved and CR removed it from the Select statement, which cannot be directly edited.

Thanks again