page header not visible

[coa]

I have created a report with several sub-reports that work fine. I then added a subreport from a crosstab query. The column headers (years) of the page header are not visible in thesub-report. The query ran fine. The report from the crosstab query will show the design view but not the preview view. I get a pop-up that says"The Microsoft Jet database engine does not recognize 'tblRepairData.fldLocation_No' name or expression. I never typed any of these items into my query or report. they were clicked on or created by access.

 

[KevinM]

Cross tab queries have dynamic columns and are not well suited for reports. Everytime a new column is generated or removed by the query then you will need to manually change these columns in the report design view.

It's the same as removing fields from a table and not removing them form a report, query or form.

The error you are getting suggests that a column in the query no longer exists yet your report is still trying to show it.

 

[coa]

Revised question: The column headers ARE visible in the sub-report page header created in the report in the design view. They do not appear when switched to the preview view

 

[KevinM]

As your data changes, so does the columns in the crosstab query.

Do all columns in the report match those in the query.

I would think not.

 

[coa]

Yes, the column headings are the same. The crosstab generated the years from the available data from the table. I did not want the totals column, so I deleted it from the crosstab. Then I created the report from that query. The years show in the design view of the report but does not allow the preview view. The years show in the design view but not the preview view after placed as a subreport in a report.

 

[Rich]

Page headers on subReports are not visible when viewed from the main report, only the SubReport header