Group Records

[Guest]

I have a report that shows one whole record. (It actually looks like a
form). It has three sections. Group Info, Medical and Dental Info, Claim
Info. The report includes a Group ID, Medical ID and/or Dental ID.

Say Group ID 71 has more than one medical records. Each medical record has
it's own ID. Group ID 71 may also have more than one dental records. Each
dental record has it's own ID.

For example, when I run my report for Group ID 71, I generate 6 reports.
This group may have 4 medical records and 2 dental records. Because an ID is
generated for each medical/dental record, I end up with 6 separate reports
for one group.

Problem is, I may have cases where a Group has the same medical/dental
information. The only field that is different is the medical/dental ID
fields. Is there a way to show Group ID 71 and include all the information
for medical and dental in one report? If any info is different in a field,
then I would want a separate report.

There may be cases where there are 20 medical records. Administrators don't
want 20 separate reports if all the information is the same. They do not
understand primary keys.

Any ideas, I'm clueless? Not sure if this can be done.

JS

 

[Marshall Barton]

I have a report that shows one whole record. (It actually looks like a
form). It has three sections. Group Info, Medical and Dental Info, Claim
Info. The report includes a Group ID, Medical ID and/or Dental ID.

Say Group ID 71 has more than one medical records. Each medical record has
it's own ID. Group ID 71 may also have more than one dental records. Each
dental record has it's own ID.

For example, when I run my report for Group ID 71, I generate 6 reports.
This group may have 4 medical records and 2 dental records. Because an ID is
generated for each medical/dental record, I end up with 6 separate reports
for one group.

Problem is, I may have cases where a Group has the same medical/dental
information. The only field that is different is the medical/dental ID
fields. Is there a way to show Group ID 71 and include all the information
for medical and dental in one report? If any info is different in a field,
then I would want a separate report.

Use the report's Sorting and Grouping window (View menu) to
create a group with header on the GroupID field. Then try
putting the group data in the header section and the medical
data in the detail section.

 

[Guest]

Thank you Marsh. I will give it a try.

Use the report's Sorting and Grouping window (View menu) to
create a group with header on the GroupID field. Then try
putting the group data in the header section and the medical
data in the detail section.