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.
- Ravi
True greatness consists in being great in little things.
- Charles Simmons