Invisible presence of values in reports

[Chrysippo]

A report based on a query has values not shown in one field but which nonetheless are taken into account for calculations of totals. The query datasheet view shows these values, only in the report are they missing. Values not shown occur when they are the same as the previous value in that field (column). Thus if two consecutive records have the same amounts in their number fields the final (and third) field in the second record will show a blank. However, the amount that should be there will be included in sub totals which are correct. Hard copy also shows the blanks. The third field is one calculated from the results of the first and second fields and the second itself is also calculated using the data from the first field. I am puzzled - if the datasheet is ok then the problem I assume lies not in the record source code nor in its formulae. There is very little code in the report itself and what there is mainly concerns control focus; closing of report and printing options occur after report is loaded.
Cheers

[NeoPa]

It seems to me that the control designed to show this field has got the HideDuplicates property set to Yes by mistake. I'm sure if you set that correctly all will return to normal.

[Chrysippo]

Thank you NeoPa - am I red faced, I never scroll down that far on format properties even when building the template report on which all are based. How one report amongst a dozen become so afflicted I do not know - must be my clumsy plonking on the keyboard. And also you've revealed to me a useful property - should have remembered RTFM from the old days. Now I wonder if this switch thing by the mains plug has anything to do with the tv not coming on.
Cheers

[NeoPa]

I wouldn't say there's anything much to be red-faced about. There would be for me, but that's something I have a lot of experience in. If you don't already know it's there then it's hard to know the question to ask, and I also doubt if that FManual would have helped a great deal without knowing exactly where to look ;-)