Counting the total amount of rows in a subreport?

[offie]

This seems simple but I can't figure it out:

I have a report with project numbers and a subreport with trade numbers:

Project A


Trade X
Trade Y
Trade Z
Project B
Trade Y
Trade Z

I would want to get a vlue of 5 rather than 2 (which would be =count(*)).

I tried, using the expression builder

=Count( [FieldNotCompleted subreport1].Report![TradeCode] )

but I get the "Enter parameter value" box.

Any ideas? Thanks!

[ItsMe]

Do you have a header or footer for the detail section with the field you are trying to use the Count() function with? Try placing your unbound control in the relative footer or header and use your expression there.

[offie]

The footer in the subreport? That wouldn't give me what I want. I actually figured it out, made another subreport with the query with all the info but didnt give it any relationship to the report, then counted that (in the header).