Hi

I'm having problems creating a complex report.

My report shows details of Research Grants within an organisation. Each Research Grant has zero or many Applicants. Each Applicant can belong to zero or many Units. I want to be able to display the information as follows:

Research Grant details
Applicant1, Unit1, Unit2, Unit3
Applicant2, Unit1
Applicant3, Unit1, Unit2, Unit3

I am using three different views to bring back the information, one for the Research Grant, one for its Applicants and one for the Units an Applicant belongs to.

I display the Research Grant details in the main report and the Applicant details for each Grant in a subreport. I am having trouble displaying the Unit information for each Applicant as Crystal does not allow me to put a subreport within a subreport. I have tried various formulas but these produce incorrect results.

Please can anyone suggest anything?
Thanks!