Supposing I'm modelling Departments and Persons. Person is used in the app in a number of ways. Departments can have a number of Persons. So, on the Department form is a subform allowing a number of DepartmentPerson records to be entered. Each has a bidirectional lookup to Person, and a SingleLine text field allowing the 'role' within the Department to be specified. That's all fine.

Now I write a report based on Department. I can display all the usual things (Department name etc.) and I can also select a subform in the Column Properties, and so display the contents of the Person lookup (e.g. name) for each DepartmentPerson child row ... but how do I display anything else from Person on that particular report, e.g. phone number, email address etc? I know I can make a custom hrml page - but then I'll lose all the build-in report functionality (order columns, search, etc.)

I'll be grateful to hear if there's a way of doing this in reports ... plus, can anyone tell me where to find reference documentation for a Deluge report definition? If I knew all the options there, maybe I could figure a way to script this. (Some way of scripting arbitrary data into an array, then telling Zoho 'rreport this', would be great.)

Thanks in advance for any leads.