Looking for a function to change field display order

[davemcguigan]

Hi, I've just started using (fairly basic) formulae in reports, but I can't find a function which will swap the display order of two fields in the report based on a condition.
It's for printing address labels, and I want to be able to say "If field x = 1 then "swap display order of" field x and field z"
Is that clear? Can anyone help?
Thanks!

 

[SteveFairclough]

In answer to the original question, you could solve this by using just two formulas as follows :-

Formula 1
if fieldx = 1 then fieldz else fieldy

Formula 2
if fieldx = 1 then fieldy else fieldz

If you display these two next to each other on the report, fieldy and fieldz will swap places depending on the value of fieldx

Hope this helps.