Unanswered: How can I get a count from a subreport field?
How can I get a count from a subreport field?
Example: I have a subreport (Activity_Subreport) within my main report (Weekly_Activity_Report) and I am trying to count the number of activities for a particular server. The report is grouped by server. I tried modifying the following function, no luck.
I used the =Count(*) to count the first field (Activity_Server) in my subreport “Activity_Subreport” and the same =Count(*) to count the second field (Activity_Driver) in the same subreport. The count function is not working. It returns incorrect counts.
I am placing my totals in the “Server Name Footer” section of the main report.
Count(*) counts the number of records in the group. It is not field specific.
Counting the first field... what does that mean? Count how many entries there are in that field?? If that is the case, then you might need to try CountA() or you'll need to put calculated expressions in your query for your report to sum.