Report opens but does not process

  • Thread starter Thread starter Rebacca
  • Start date Start date
R

Rebacca

I desperately need direction on solving this problem.

I created a new report but when opened it does nothing
except fire the open and close events.

I have looked at it for an entire day and can see nothing
wrong. It is based on a cross-tab query. I even changed
the input query to be one I have tested manually but still
the report just opens and closes. NO other report events
trigger and it does not format or print even the page
header. The report does contain a chart if thats a factor.

Help please, I don't know where to go from here!
 
Are you having the same problem with any other reports? Have you tried
building a new test report to see if the same problem happens?

Consider trying these -- if nothing else has a problem, perhaps the report
is subtly corrupted. Try creating the same report again, from scratch...

Good luck

Jeff Boyce
<Access MVP>
 
Ok, I found there was an 'on error' trap masking the error.
The error is " not recognized as a field name or
expression. Any idea how I can trace this, the debugger
stops on the OpenReport statement. The OnError report
event does not fire. This has held me up for 2 days.
Rebecca
 
Rebecca

Based on the error message, I'd take another look at every control, to
ensure that the source fieldname is spelled correctly.

By the way, does your report's underlying query have the correct data?

Good luck

Jeff Boyce
<Access MVP>
 
I found out the message is displaying two single quotes.
I've looked at everything I can think of.
This report is based off a crosstab query that forces the
number of columns regardless of whether data is found for
each column. Is that a problem? The column names are
numeric 1 thru 8. Is that a problem?
If a particular row does not have data for a column would
that cause this error? Do I have to test each column for a
null or something?
The underlying query works fine.
I wish Access could come up with more meaningful error
messages.
 
Rebecca

We're out of my area now. Consider re-posting, but with this additional
clarification.

Good luck

Jeff Boyce
<Access MVP>
 
Rebecca,

You said that this report uses a crosstab query as its source.

Do you have an In clause in the pivot statement that forces each column (1 to 8)
to exist? If you don't, then if one of the columns doesn't exist in the query
(due to no data matching that column) then the Report will NOT have the column
available and this will fail. Can you post the SQL statement you are using.

For example, you should have a line in the SQL statement that looks something like:

....
PIVOT Interventions.ProjectCode In (1,2,3,4,5,6,7,8)

Or perhaps
PIVOT Interventions.ProjectCode In ("1","2","3",...)
 
Back
Top