Custom Field Grouping
Hi,
I have a string data field that i want to use for grouping in a report.
However, i only want to group on the first 10 characters of that field. I
created a string variable (dropped a variable on the report) that copies the
first 10 chars. I realise that one can group on variables (custom field),
but how do you get the timing right. i.e. so that the value of the variable
is worked out before the groups are?
regards,
gilbert
Cura Risk Management Software
I have a string data field that i want to use for grouping in a report.
However, i only want to group on the first 10 characters of that field. I
created a string variable (dropped a variable on the report) that copies the
first 10 chars. I realise that one can group on variables (custom field),
but how do you get the timing right. i.e. so that the value of the variable
is worked out before the groups are?
regards,
gilbert
Cura Risk Management Software
This discussion has been closed.
Comments
Use the Variable.OnGetText event rather than OnCalc. (OnCalc occurs too
late.)
--
Nard Moseley
Digital Metaphors
http://www.digital-metaphors.com
Best regards,
Nard Moseley
Digital Metaphors
www.digital-metaphors.com