report from crosstab query

  • Thread starter Thread starter hermie
  • Start date Start date
H

hermie

In my report from a crosstab query I have included all fields which can
occur in the crosstab query. Sometimes not all fields are in the
crosstab_query. Which causes a message that say cannot recognize Field X as
a valid field or expression. But I have these fields in the report design.
How can I manege the design that is shows 0 values in the report? I made an
textbox like: =IIf(IsNull([Cuarto año]),0,[Cuarto año]) but that does not
work.

Any solution is welcome

Herman
 
Have you tried to add all fields into the Column Headings property of the
Crosstab?
 
As far as I know I can only have 1 Column heading in a crosstab query?


Duane Hookom said:
Have you tried to add all fields into the Column Headings property of the
Crosstab?

--
Duane Hookom
MS Access MVP
--

hermie said:
In my report from a crosstab query I have included all fields which can
occur in the crosstab query. Sometimes not all fields are in the
crosstab_query. Which causes a message that say cannot recognize Field X as
a valid field or expression. But I have these fields in the report design.
How can I manege the design that is shows 0 values in the report? I made an
textbox like: =IIf(IsNull([Cuarto año]),0,[Cuarto año]) but that does not
work.

Any solution is welcome

Herman
Click to expand...
Click to expand...
 
There is a Column Heading property of the crosstab where you can type in all
possible derived column headings. For instance if your column heading
expression is:
ColHead: Format([SaleDate],"mmm")
you would enter the following in the Column Headings property:
Column Headings: "Jan","Feb","Mar","Apr",..."Dec"
--
Duane Hookom
MS Access MVP
--

hermie said:
As far as I know I can only have 1 Column heading in a crosstab query?


Duane Hookom said:
Have you tried to add all fields into the Column Headings property of the
Crosstab?

--
Duane Hookom
MS Access MVP
--

hermie said:
In my report from a crosstab query I have included all fields which can
occur in the crosstab query. Sometimes not all fields are in the
crosstab_query. Which causes a message that say cannot recognize Field
Click to expand...
X
as
a valid field or expression. But I have these fields in the report design.
How can I manege the design that is shows 0 values in the report? I
Click to expand...
made
an
textbox like: =IIf(IsNull([Cuarto año]),0,[Cuarto año]) but that does not
work.

Any solution is welcome

Herman
Click to expand...
Click to expand...
Click to expand...
 
Thanks Duane It works Never thought it was possible to do, because I could
not find this in the Help function of access.

Herman
Duane Hookom said:
There is a Column Heading property of the crosstab where you can type in all
possible derived column headings. For instance if your column heading
expression is:
ColHead: Format([SaleDate],"mmm")
you would enter the following in the Column Headings property:
Column Headings: "Jan","Feb","Mar","Apr",..."Dec"
--
Duane Hookom
MS Access MVP
--

hermie said:
As far as I know I can only have 1 Column heading in a crosstab query?
Click to expand...
Field
X
as
a valid field or expression. But I have these fields in the report design.
How can I manege the design that is shows 0 values in the report? I made
an
textbox like: =IIf(IsNull([Cuarto año]),0,[Cuarto año]) but that
Click to expand...
does
not
work.

Any solution is welcome

Herman
Click to expand...
Click to expand...
Click to expand...
 
Back
Top