Get List Layout to display all portal record rows?

[Rramjet]

Hi -

I am an intermediate FM 10 user on a windows platform and I want to create a List layout displaying information from a portal - but the list only displays information from the first row of each portal.

I would also like to produce a summary report, but the same result occurs - only information from the first portal row is displayed.

Each row of my portal contains:

Med_cat, Med_name, Dose, Date_initiated, Date_Discontinued.

...and each patient might be on a number of different medications (and may also discontinue one med. only to start again at a later date).

I have the portal sorting by Med_cat and Date initiated (with conditional formatting making each medication category a different text colour - just for ease of immediate recognition...)

I want to produce a List layout as follows:

Patient_ID, Patient_name, Med_cat, Med_Name, Dose, Date_In, Date_Dis

Initially I tried displaying the medications info using repeating fields but that turned out to be space and time consuming and virtually impossible to maintain (not to mention confusing for data entry!). I found using a portal an efficient method both for primary layout display and for data entry purposes.

Any help with a solution to get the List Layout (and/or summary report) to display all portal rows for each patient would be greatly appreciated.

Cheers,

Rramjet.

PS: I do not want to have to return to repeating fields if at all possible :

[mr_vodka]

Your report would have to be based on the child records. In this case I am going to assume that it is the Medicine table.

You can put the related parent patient Info on it.

You can create a subsummary report if you wish grouped by patientID.

You havent specified your structure, so I can only take a guess here.

[Rramjet]

Hi John -

Please forgive me for my naivety! - for the report I was not pointing FM to get the info from the correct table! FM was trying to get the info from the parent (Patent_Details) table when I should have pointed it to the Medication_Details table. Sorry. Now I have a report displaying all portal info...

...but I still do not have a List Layout displaying all portal info. Maybe I being just stupid here too?

I'll work on it some more...

humbled thanks,

Rramjet

Edited August 4, 2009 by Guest