I have a crosstab report that summarizes a field number and distinct counts another field form the same table. The count ad the summary values are correct. Below is an example of the crosstab placed in the report footer.
the Field2(Summary) resets by the grouped 'area' field to calculate individual summaries for each area. Change of field is by Field2.
Crosstab:
-----------------------------------------------
area Field1(count) Field2(Summary)
-----------------------------------------------
1 23 26374.89
2 50 532900.99
3 12 4782.78
4 34 38989.34
------------------------------------------------------------
Total 119 603048.00
------------------------------------------------------------
This report also has a details section that has several fields in it. It seems like some of the fields, when placed in the detail section, changes the Field2Summary values for each 'area' , but the Field1(count) remains the same. I tried to play around with the table links, but that doesn't help. I put the detail fields in the group header, that didn't work either. Below is what I get. Does anybody have a clue as to what can be done to avoid affecting the Field2(Summary) values, no matter what is on the detail section of the report?. Any help will be appreciated!
Crosstab:
-----------------------------------------------
area Field1(count) Field2(Summary)
-----------------------------------------------
1 23 28789.22
2 50 5569970.45
3 12 4999.45
4 34 39999.67
------------------------------------------------------------
Total 119 5643758.79
------------------------------------------------------------
IP Logged