View Full Version : Redundant Data on Report for Each Account!!


joe789
05-03-2001, 10:13 AM
Hi Folks,

I have created a report based on a table. I am using the SUM funtion for a few fields. The problem is that the first page of the report is repeated for each account. If I have ten accounts, the same value is displayed ten times. Given the nature of my report, I do not need the report to be repeated as many times as there are accounts in my table -- all of the data would be exactly the same anyway. I have selected Hide Dulplicated to YES from the properties command for each field; but this does not work. Can someone please help me. Thank you very much.

Joe

Pat Hartman
05-03-2001, 12:08 PM
If you are summarizing to a higher level than account, remove account from the query.