count in a report

[N06149]

I have a report based on a query. I list an Org_Type then Org_Name then the Projects associated with it. Sample of report below:

Community Type
---------------------------------------------------------Org_Type Header
Org_Name bla bla bla
project a
project b
project c
-----------------------------------------------------------Org_Type Footer
(=Count(*) & " Records")


-----------------------------------------------------------Report Footer
(=Count(*) & " Records")


I have a count set up in the organization type FOOTER (=Count(*) & " Records"), and a overall count in the report FOOTER (=Count(*) & " Records"). I'm getting the Count for the number of Projects associated with each Org_Name. I don't want the Projects counted, I want the Org_Names counted. The reason I have the count in the Org_Type Footer, is so it counts a subtotal for all Org_Names that fall under the Org_Type. If I put the count in the Org_Name FOOTER, I get a subtotal after each Org_Name. This I don't want. How can I get the subtotal of all Org_Names while leaving the Count in the Org_Type FOOTER??? It should look like this:

Academic Type
-------------------------------------------
Org_Name bla bla bla
project a
project b
Org_Name bla bla bla
project c
--------------------------------------
SUBTOTAL = 2 (not 3) (should count names not projects)

Is there a way like =count(some specific field)????

[BradHodge]

Take a look at this post and see if it gets you going in the right direction.



Welcome to theScripts!