How can I populate a field in a report footer with a select lookup. (SQL /RS 2005)
I wish to do a simple SELECT statement and return the value to a textbox in my report footer.
I am looking up a single item e.g. "SELECT AgentsRef FROM SystemParams WHERE ClientID = 1"
The result of this would be "Agent1".
I want the report footer to be ="Agents Ref: " & strAgenstRef