Count Totals

[farmcock]

I have report with following 4 columns:

State, District, Claim Number, Count_Claim Number

As long as Claim Number is in my report, the Count_Claim Number is accurately counted and its Summary Total is correct.

If I remove Claim Number from the report but is still in Query, the Count_Claim Number is no longer correct.

How do I get an accurate count_Claim Number Summary Total without having to have the Claim number in the report?

[Francis aka khayman]

are you using crosstab? basically whatever is not in your crosstab is disregarded even if it is in the query. anyway to achieve what you want, for crosstab, click on count claim number, in the properties tab, there should be a property called property  :o ::) :P

click on the three dots, and a property dialog box will appear which lists all the items in your query. check the Claim Number.

for lists, you can use a detail filter.

[farmcock]

I'm using a List report.

What type of detail filter would I use?

[Francis aka khayman]

sorry detail filters may not be enough.

so the problem is in the total? details part is correct?

how do you summarize your Count Claim Number? you might need to code something like:

[Count Claim No] =  total(Count Claim Number for Claim Number)

[Lynn]

Did you try adding the claim number into the "Properties" property for the list?

[Robl]

It depends where the total is on the report.
Is the total in the footer of the list or elsewhere on the report.
It sounds like when you remove the count the 'auto group and summarize' is just recalculating your total.

Are you 100% sure the rollup types are correct for the details and the summary?