I never did find a way to do this elegeantly.
No one has any ideas?
Do you have a table of Locations, where each location is a unique record (same question about Languages)?
Upon re-reading, I find I don't understand if the report is about an individual client, or a group (found set?) of them, or ... ?
Message was edited by: Michael Horak
I see the confusion, ok.
The report is a breakdown of information and summaries about both the Clients and the Appointments that they had during a given one month period.
There is a table of Clients with a 1-to-many relationship to a table of Appointments.
I can generate all the subsummaries within their own layouts and then save them all together as one PDF (my current working solution) however it is not pretty and there is a pagebreak after every section leading to needless blank space. Ideally I would be able to take subsummaries and lay them out together in a single layout to make it all more compact and more visually pleasing.
Is anything even remotely like that possible?
the "Location" catagory is from the appointment table and refers to the place te appointment occurred. I listed it purely as an example. It is one of many catagroies I need include in the report.
You haven't really clarified my confusion. If the report is produced from the Appointments table, and each appointment has a location attribute, you can summarize the found records by location (or by client and location).
If you also want an independent breakdown by languages (assuming each appointment also has a language attribute), then it becomes more complicated, since the sort requirements are conflicting. This is where a custom function could be useful. Alternatively, you could have a script write the summaries, one by one, into a global text field. In version 12, you also have the option of using SQL to retrieve the sub-summary values.
The challenge is that this is not "a" report, its really multiple reports. An appointment will be counted once for location, once for languages, and yet again for each other summary. However there is only one instance of the apointment, so the report needs to be generated multiple times. There is no way around the problem.
The issue is therefore one of display. I'd suggest it is an ideal canditate for virtual lists: run the various summary reports sorts sequentially to generate the virtual data, then display them once as a sumarised report.
Ok Virtual Lists sound absolutely awesome, I hadnt heard of them before. That is exactly what I was looking for.