Hi all,

I have a problem about creating crosstab report. i have a data let say inspection. it consists of inspectors field and date.

When I create crosstab report, with fields name of people vs months from jan to Dec.

the problems, when the inspections date is the same, it is only counted 1. Could anyone of you can help me?

Thanks

Hello,

Are you crosstabulating your data at the report level or do you have a crosstab query established as well?

If you have a query, you might want to check if the <<Total>> attribute in that field is set to <<Count>> or <<Group By>>. If I understood your explanation correctly :confused:, it seems like the query is counting the total number of apperences of a certain date entry.

Barbacuca

Yes I have tried to set the field each month with <<Count>> or <<Group By>>. It seems when there records are the same date it only counts 1 for example

01/05/09 - Inspection A
01/05/09 - Inspection B
01/05/09 - Inspection A

So in crosstabb Quary it only counts 1 inspection. How to make it 2
like this

Inspection Jan Feb Mar Apr May Jun Jul etc.
Inspection A 2
Inspection B 1



Hello,

Are you crosstabulating your data at the report level or do you have a crosstab query established as well?

If you have a query, you might want to check if the <<Total>> attribute in that field is set to <<Count>> or <<Group By>>. If I understood your explanation correctly :confused:, it seems like the query is counting the total number of apperences of a certain date entry.

Barbacuca