My report generate 66 same pages

[ckleung]

Hi,

I create a report to get statistics. each row has 2 text boxes. I wrote the following in the text boxes:

txtMale: =DCount("[Sex]","ForStat","[Sex]=-1")
text2: =Val([txtMale]/[txtTotalRecord])*100

I have another text box named "txtTotalRecord" to count the total record in which I write: =count([EngName])

All the other rows contain the same function with different criteria.

The no. of pages generated is equal to the no. of the records.

Can anyone help ?

 

[ckleung]

May be I need to learn more about function

Use the aggregate functions of the report to do the calculations rather than domain functions. Put the calculations in the report footer if you don't want to print any detail lines and don't put any controls in the detail section.

Pat,

Thanks for your advice. I am a new user so I indeed don't know how to do. What is aggregate function and where should I write the functions.