How to use report variables in a calculated field?
I want to pass certain numbers to a report like so:
frVariables:= ElaspsedTime;
frVariables:= GetPersonRate(cboPerson.Text);
Now in the report I have a memo field where I want to use these variables in a calculation like so:
[varTime]*[varPersonRate]
But it doesn't work as it seems to treat the variables as strings instead of numbers. Is what I want to do possible?
frVariables:= ElaspsedTime;
frVariables:= GetPersonRate(cboPerson.Text);
Now in the report I have a memo field where I want to use these variables in a calculation like so:
[varTime]*[varPersonRate]
But it doesn't work as it seems to treat the variables as strings instead of numbers. Is what I want to do possible?
Comments
check each variable first to make sure your values are passed in correctly,
if they are
try
varTime]*[varPersonRate
regards