Wrong data!

[KateB]

I have a report that is linked to a query. The query is pulling the correct
information. However, The report has part of the information from the query
in the header (i.e. GP practice, patient name, DOB) and the rest in the
detail. Each patient has one page in the report and can only have one GP but
multiple information in the detail section. I'm finding that if the GP code
(in the header section) is the same for page 1 and page 2 (i.e. 2 different
patients with the same GP) the detail changes but the patient name and DOB
doesn't - it stays as the first patient.

Any suggestions on how to cure this?

 

[KateB]

I think it might be connected to the sorting and grouping. If I change it to
sort by name or auto ID it works OK, but I need it to be in Practice order to
make it easy to distribute.

 

[Rob Parker]

You've almost solved it yourself, I suspect.

Although you posts are a little short on detail, I suspect that you've got
the general information in the Report Header section. It needs to be in a
Group Header, at the level at which you are grouping. I'm not quite sure
whether you're wanting/needing to do this at Practice level, or at Patient
level. You should put Practice-level data into a Practice group header, and
Patient-level data (other than details) into a Patient-level group header.

I think (IIRC) that you can only nest groups to 8 levels, but you can check
that in Help; it shouldn't be a practical problem for you here.

HTH,

Rob

 

[KateB]

Brilliant! Thanks Rob, that was exactly what I needed. I had it all in a
Practice header and just needed to split the patient details into a separate
header.