There are two more ways to achieve what you want in Aware IM.
The first is to use a presentation, rather than a report, to display the results of your query. Presentations are very similar to reports except that instead of a PDF file the information is displayed as HTML and you can add hyperlinks to displayed elements so that the user can go directly to data forms by clicking the hyperlinks. Presentations and reports have compatible design so you can follow the steps described above to create a report, then export the design of the report to disk, create a presentation, import the design into the presentation and make necessary changes to enable hyperlinks. You can then specify that the Account query should display the results using the presentation.
The other way is even easier and does not require creating reports or presentations. Instead of query on Account you define a query on Prospect. This implies that object Prospect has a non-multiple attribute Account (matching to attribute Account.Prospects) that points to the account the prospect belongs (or is related) to. Object Prospect should also have a shortcut attribute AccountNumber with attribute path set to Account.Number. Now your query can look like this:
FIND ALL Prospect ORDER BY Prospect.AccountNumber, Prospect.LastName
You can select desired attributes of Prospect to be displayed for the query results, including the shortcut attribute AccountNumber to show the account number. Due to the specified sort order all the prospects will be displayed grouped by their account. This is how you can display both account and prospect information without having to use embedded lists.
You can further modify the query to be more useful by adding any desired parameters. For example, if you want to show prospects for a specific account identified by number that the user would specify at run-time, the query can look like this:
FIND Prospect WHERE Prospect.Account.Number CONTAINS ?'Account number' ORDER BY Prospect.AccountNumber, Prospect.LastName
When running this query the system will automatically display the parameters window where the user can type the account number or its part. Note that if the user does not type anything, the system will ignore the condition and display prospects for all accounts. Even then, on the query result page the user can further filter the search results to narrow down or extend the list.
Let me know if any of these solutions are acceptable to you or if you have further questions.
Aware IM Support Team