Failure of report based on crosstab query to execute.

  • Thread starter Thread starter Terry
  • Start date Start date
T

Terry

I have a report that is based on a crosstab query that
does not execute because the database engine does not
recognize an expression. The column expressions listed
on the report may or may not be found by the query for a
given time frame. How can I get the report to continue
execution and print the report?
 
You have to find a method of either making sure the fields/columns are
consistent or you modify the report with code to fit the columns. You can
set the Column Headings property of the crosstab to make sure all columns
are returned.

To view several different solutions, download the sample from
http://www.invisibleinc.com/divFiles.cfm?divDivID=4
 
Back
Top