I have a simple database to record clients who visit a free legal advice clinic I volunteer at.
The database records the 1. name of the client 2. date of their visit 3. the legal area of their problem 4. How they heard of us 5. other details Currently I produce three reports 1. A two level report showing for each period, for each legal area the number of clients needing this help: eg Employment 3 Housing 4 Consumer 5 etc 2. a two level report showing for each period, how clients heard of us eg CAB 5 Existing client 5 Internet search 5 etc 3. a two level report, showing for a period, how many clients came each week: eg 01/07/2009 5 15/07/2009 5 22/07/2009 7 etc Each one has appropriate indexes to create the two level report desired I have no problem producing these as individual reports. What I would like to do is produce one report using virtual link sub-reports (ie parallel sub-reports, to use Ralph Alvy’s terminology), so that I select the start and end date once using Prompt for Value of Report Value. Again I have no problem with using this method and using the Skip To and Skip If iteration commands for an individual report, but doing 3 parallel reports particularly where the two-level is not sorted on date, does not produce the desired result. It appears to be a problem with indexes, but despite reading the Iteration Control and Sub-report chapters in detail I cannot locate the problem or an example of what I want. A copy of the database is available for download at http://www.rlas.org.uk/Download/rlas-c3.zip. Example of each of 3 reports are provided (created as individual reports) Help with this would be very much appreciated. Victor Warner _______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf
