N
Nenad Markovic
Hi everybody,
When executing a Crosstab Query I see only rows (defined in a row heading) that have values (defined in value field) in at least one column (defined as column headings). How can I make a Crosstab Query that shows all rows, regardless they have values in column headings.
For instance, the result that I get now is like this
AreaID Class_1_ID Class_2_Val_1 Class_2_val_2 Total_Class_1_ID
1 2 10 20 30
1 3 5 15 20
2 1 6 30 36
2 2 10 10
2 3 20 20 40
3 1 10 10 20
3 2 15 15 30
3 3 10 10 20
4 1 15 20 35
4 3 10 15 25
AreaID, Class_1_ID and Total_Class_1_ID are Row Headings;
Class_2 is the Column Heading
The Value field is defined as expression: Count(..
So, for the Area 1, in Class_1_ID=1 there are no values for neither column in Crosstab result, so it is not shown. For the Area 4 there are no values for Class_1_ID=2 for neither column in Crosstab result, so the whole row is not shown. Of course, the Class_1_ID values are prederfined and limited (there are classes 1, 2 and 3)
Is there a way to show these rows? Or can this be solved in a Report based on this Crosstab Query? Something like Column Headings property that can be defined in a Query properties dialog box, but for rows?
Thanking you in advance,
Nesha
When executing a Crosstab Query I see only rows (defined in a row heading) that have values (defined in value field) in at least one column (defined as column headings). How can I make a Crosstab Query that shows all rows, regardless they have values in column headings.
For instance, the result that I get now is like this
AreaID Class_1_ID Class_2_Val_1 Class_2_val_2 Total_Class_1_ID
1 2 10 20 30
1 3 5 15 20
2 1 6 30 36
2 2 10 10
2 3 20 20 40
3 1 10 10 20
3 2 15 15 30
3 3 10 10 20
4 1 15 20 35
4 3 10 15 25
AreaID, Class_1_ID and Total_Class_1_ID are Row Headings;
Class_2 is the Column Heading
The Value field is defined as expression: Count(..
So, for the Area 1, in Class_1_ID=1 there are no values for neither column in Crosstab result, so it is not shown. For the Area 4 there are no values for Class_1_ID=2 for neither column in Crosstab result, so the whole row is not shown. Of course, the Class_1_ID values are prederfined and limited (there are classes 1, 2 and 3)
Is there a way to show these rows? Or can this be solved in a Report based on this Crosstab Query? Something like Column Headings property that can be defined in a Query properties dialog box, but for rows?
Thanking you in advance,
Nesha