Hi all,

I have a requirement to add a calculated field to a report in VB6 using the report designer. The reports recordset is the result of a parameterized SQL query. I need to take a SUM() value in a group footer, and if the value is greated that 50, do one thing, else do another.

The problem I am having is that I cannot seem to add a textbox to the report that is not tied to a field in the datasource. When I try to put a IIF() wrapper around the field name, the report writer chokes at runtime.

Anyone done anything like this in VB6 yet? I guess I'm looking for a textbox control I can place on the report where I define the exact and complete function/expression that gets executed. This ability has been in FoxPro/VFP for years, I'm surprised it's not as obvious to me in VB. Perhaps I have missed something...

TIA,
Phil