Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to achieve multiple detail bands with columns?
Message
From
10/07/2003 16:42:49
Henry Ravichander
RC Management Systems Inc.
Saskatchewan, Canada
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Title:
How to achieve multiple detail bands with columns?
Miscellaneous
Thread ID:
00809019
Message ID:
00809019
Views:
85
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
Next
Reply
Map
View

Click here to load this message in the networking platform