Here is another way if you don't care to use SQL and stack boxes in reports...try calling functions that format and return the data you need. It works great for me and keeps things more like a WYSIWYG report when designing it. E-Mail me for more info and sample pics if anyone is interested.

Paul

>Hi all:
>
>Data source fo this report is from 4 different tables. The first source contains a health number and 3 memo fields which are updated to refelct fmaily histroy, allergies etc. Therefore, there will only be one record per client in this table. The remaining tables have a field that stores the health number and other fields such as current condition, treatment plan and the like. Difference here is that there can be more than one record for a client in each of these tables with variations between each table.
>
>All of the data are in cursors and are then assigned to variables.
>
>Goal: To achieve a 2 column report that can be updated and filed in each chart. The desired layout is:
>
>

- Personal & Family Data                    - Ongoing Health
>  (from mPersonalData)                        (from mCondition)
>
>
>
>- Past History                              - Medications
>(from mPastHist)                              (from mRegimen)
>
>
>
>- Allergies                                 - Consultations
>(from mAllergies)                             (from mConsultants)
>
>

>
>This should preferably be on one page.
>
>I developed an initial report, with just one detail band and placed controls for mPersonalData, mPastHist and mAllergies. The out come was that even though there was only 1 record in mPersonalData, it was displyed 3 times.
>Not sure waht the problem is.
>
>Your guidance is greatly appreciated. Thank you.