By dynamic do you mean you need a field that is capable of displaying various fields from the database based on the user's requirements at run time? Cheers
Well in the past I've done this by asking the user to select the field they want to display via a parameter at runtime.
The formula for the dynamic field looks like this
if {?.Parameterfield} = "Name" then table.Name else
if {?.Parameterfield} = "Age" then table.Age else
if {?.Parameterfield} = "Company" then table.Company
etc!
So you create a parameter field named {?.Parameterfield} in the example above and then enter the selection you wish the user to see at runtime and enter this into the the if statement in a formula against the corresponding field.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.