cfreturn variable return separate fields

[Cozmo2]

I am creating a report in CF 10 report builder. I have a function that returns two separate fields in one variable I need to have the two fields returned separately, my output is an excel worksheet. Any advise will be greatly appreciated.

[EddieLotter]

Cozmo2 wrote:

I am creating a report in CF 10 report builder. I have a function that returns two separate fields in one variable I need to have the two fields returned separately, my output is an excel worksheet. Any advise will be greatly appreciated.

A function can only return a singe value.

If you need two values you will need two functions or you will need to call the same function twice with a parameter indicating which value you want returned.