Record Count in a "dynamic" Report

[spitzmuller]

Hi out there

I have a report that I dynamically configure using the "Report_Open"-Method (called on the OnOpen-Event) when the Report is opened: among other stuff I dynamically set the ControlSource of the Textboxes in the details Section so that it will fit a selection made by the user.

Now my Problem is that I couldn't figure out a way to print the count of all records in the report footer

I tried "=Count(*)" as ControlSource in a textbox (and other stuff as well) but all I get is #Error

Thanks for your help

Simon

 

[CosmoKramer]

Simon,

I know you said in your post that the text box is in the report footer. But, are you sure its not in the page footer?

Is there a RecordSource defined for your report, either through the properties window, or through your OnOpen event?? If not, the [tt]=count(*)[/tt] will not work....

I'm CosmoKramer, and I approve this message.

 

[spitzmuller]

Thanks CosmoKramer

Exactly right. I had it in the page footer... Works now. Thanks!

Just for kicks: if I wanted the record count to appear in the Report's Page Footer, how would I do that?

Cheers Simon