Question for GROUPING in REPORT

[rmunteanu]

Hello,
I need your help. I am realy .
I have made a report that is grouping data by a category. I would like the report to show the total rows only for categories that have more than 1 row in the report. If one category has only one row, I want the report to show only the data row, without the total,so I will not have double rows, like:
"1. books.........3
TOTAL Books....3"
The total row here is useless because it is only one row to group.
Can you help me fix this?
Thanks!

 

[ted.martin]

If you are running Access 2007, there should be the option to do what you require. If you are on a previous version, have you tried using Sub-Reports? They are a little like Sub-Forms.

 

[Mattster]

I would use the onformat for the total section, and change the visibility setting on whatever. You should be able to use a count, to determine the number of records, or just setup a counting field in the query. The onformat would look something like
if Count = 1 then
TotalBooks.visible = false
else
TotalBooks.visible = true
end if

 

[rmunteanu]

Hi. I am using 2007 but I did not find such option. Can you direct me to it?