Strange behaviour - Access Reports - 2003.

[Darragh]

Scenario: Removed a field from a database, and attempted to remove it
from several reports as it was now not used. Removed the field from
the query running the report, but forgot that there had been grouping
levels on that field within the report design. Saved the report. Found
that I could not run/design the report once I had done this - running
on the report from the database window, the mouse icon would flicker
and not do anything. Ran the report from code and would get an error
"open report action was cancelled".

Had to delete report, import from a backup, remove the fileds from the
report design, query that ran the report AND the grouping level. Once
this complete, I could run/design the report as intended.

Decompile/compact/repair did not fix this issue. I'm guessing the
error occurs because Access tries to group by on a report with a field
that no longer exists.

Any ideas on what could cause this - or is this a known bug?

Regards

Darragh

 

[Wayne-I-M]

Hi Darragh

I can’t replicate your problem. I removed a field from a table and query
but left the field in the report. I also left the field in the sorting and
grouping. The only problem I had was a parameter request.

When I also removed the field from the report design, but still left the
sorting option the report open – but not sorted.

There may be another problem with your DB, or I may have not replicated
exactly your situation.