Walter,
Your formula references what I'm assuming is a datatable called NHGList (for the state and city). Are you creating a datatable with that name at runtime, and setting that as the datasource for the report?
(Maybe a more general question is how you're handling the data for the report at runtime).
Kevin