Help needed with displaying Crosstab data in a Report

[Ginny2222]

Hi all, help with this would be appreciated.

I have a crosstab query which returns values in a range of categories. I have 5 categories. My problem is that sometimes a category may not return a value in 1 or more of the categories. This means that when I am displaying this data in my report I haven't got the data in the correct columns.

In the underlying queries for this I tried using a LEFT JOIN forcing the category, but when I executed the crosstab I got errors in all fields.

Thanks in advance
Ginny

 

[EMP]

You can force the crosstab query to display all the column heads by adding an In Clause after the Pivot Clause in query SQL View e.g.

TRANSFORM ..........
SELECT ..........
FROM ........
GROUP BY ..........
PIVOT ......... IN ("column headA","column headB", ...,"column headX");

^

 

[Ginny2222]

Thank you, - problem solved. Complete newbie here, this forum is great and I appreciate the help.

Ginny

You can force the crosstab query to display all the column heads by adding an In Clause after the Pivot Clause in query SQL View e.g.

TRANSFORM ..........
SELECT ..........
FROM ........
GROUP BY ..........
PIVOT ......... IN ("column headA","column headB", ...,"column headX");

^