report from crosstab query

[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

 

[Duane Hookom]

Have you tried to add all fields into the Column Headings property of the
Crosstab?

 

[hermie]

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

Have you tried to add all fields into the Column Headings property of the
Crosstab?

--
Duane Hookom
MS Access MVP
--

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

 

[Duane Hookom]

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
--

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

Have you tried to add all fields into the Column Headings property of the
Crosstab?

--
Duane Hookom
MS Access MVP
--

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

 

[hermie]

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

Herman

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
--

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

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