I have a portal with instructors names. I need to have a global field for a report that can list all the instructors.
Works fine with one instructor, but how do I pull the contents of portal row 1, 2, and 3 if there is more than one instructor?
thanks.
List ( PortalTableNameHere::InstructorName )
Will produce a list of names with returns separating each name. You can use substitute to replace the returns with other characters such as commas.
And ExecuteSQL can do the same, but with options that can sort the data into a specific order and/or use a WHERE clause to only list records matching specific criteria.