Report summary

[nblade]

Hi,

I'm new to databases, atm working on one for the school. My question involves reports.

I've managed to successfully set up queries to pull the necessary data based on specific criteria. So now I want to setup some reports to display the information. The problem is that I don't want/need the actual data to be displayed in the reports, but rather only counts of the items from categories.

Changing the Visible field doesn't seem to produce what I want nor does deleting the actual boxes. The total number of pages still reflect all the data even when the data isn't shown.

Can someone point me in the general direction? Don't have to be specific, I'd just like to know where to go in order to fix this.

Thanks!

 

[Mike H.]

If I get this right, you only want to count the number of records , I do this by going into design mode within the report and make sure "report footer" is visable ( you usually have to extend it down) and insert a test box with the label. The text box will be "unbound" right click on it and go intp "properties" Go into "Data" and click the three doots to the right of Control Source to bring up the Expression Builder. First click the = sign , then Double click "Functions" then "Buillt-in Functions" in the left window, then "SQL Aggregate" in the middle window, then double click "Count" You should see this = Count (<<expr>>) , now just insert the record field you want to Count into the <<expr>> area and that should do it.

 

[nblade]

Perfect!

Haha, wow that was simple! My mistake was putting the Count fields in the Detail area instead of the Report Footer area.

So in case anyone else runs into the same problem in the future: Follow Mike's suggestion and make sure the Visible option for Detail is set to hidden.

Many thanks!

 

[KatCanDo]

Hey Mike!

I am working on a similar problem. I have multiple reports with the report footer returning a count for me. Do you have any suggestions on on to do a summary report that would list all of the counts from the multiple detail reports I have. I thought about subreports but I only need the information from the report footers and my attempt at pulling that field into another report was a bust.

Any suggestions would be welcomed--thanks.