DistinctCount not showing on 1st page

[adoctor]

Hello-

This is probably a simple fix, but I'm not understanding why it's happening.

I have a simple report that contains one-to-many releationships, one Constituent to many object records. I have put a DistinctCount for Constituent ID in the footer, and it works on all pages EXCEPT the first page where it says the count is '0'.

Here's the formula that I put in the footer:

 DistinctCount ({Constituents.ConstituentID})

Can you tell me what the problem might be?

Thanks,

Angie

 

[synapsevampire]

Two ways that should work:

Right click the page header and select insert secton below.

Place the formula in this new section, then right click the new section and select suppress.

This way it's been computed and the page footer will now observe it.

OR

Create a faux page footer...

Create a formula of

if {Constituents.ConstituentID} =-9999.919 then
0
else
1

Group on this and select repeat group header on each page in the Options area.

Suppress the group footer.

Place the disticnctcount formula in the group header, and then right click the group header and select section expert and turn on the print at bottom of page.

-k