I have a report where I need to sum in the report footer. I need to sum a text value so what I have done is created an invisible field in the client header with:
Control source: =IIf([ControlName]="X",1,0)
Name: Count1
Then in the footer, I am trying to place a sum function with a control source of =Sum([Count1]). When I view my report though, I get an enter parameter value dialog box asking for Count1. What am I doing wrong on my sum?