Parameter Fields

[dcjames]

I want to create a report where the user can determine the field order of the report. What I've come up with so far is...

if {?First Field} = 'USER ID' then{USR.USR_LOGIN} else
if{?First Field} = 'FULL NAME' then{USR.USR_DISPLAY_NAME} else
if{?First Field} = 'OIM USER STATUS' then {USR.USR_STATUS} else
if{?First Field} = 'CREATED' then{@toTextCreateDate} else
if{?First Field} = 'EMAIL' then{USR.USR_EMAIL} else
if{?First Field} = 'HIRE DATE' then{@toTextHireDate} else
if{?First Field} = 'ORGANIZATION' then {USR.USR_UDF_ORGANIZATION} else
if {?First Field} = 'EMPLOYEE NUMBER' then {@toTextEmployeeNumber} else ""

Is there a way to have the field labels change accordingly?

Any and all help is appreciated

 

[Charliy]

You can use the parameter as the field heading, or if you need it to look different do a formula similar to your grouping formula and use that.