By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,964 Members | 1,206 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,964 IT Pros & Developers. It's quick & easy.

Invisible presence of values in reports

P: 4
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
Nov 25 '11 #1

✓ answered by 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.

Share this Question
Share on Google+
3 Replies


NeoPa
Expert Mod 15k+
P: 31,709
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.
Nov 25 '11 #2

P: 4
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
Nov 25 '11 #3

NeoPa
Expert Mod 15k+
P: 31,709
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 ;-)
Nov 25 '11 #4

Post your reply

Sign in to post your reply or Sign up for a free account.