Separating sub-summary parts

[AnnaC]

Hi,

I have a report layout on which i want to show several sub-summaries for different fields. For example i have a trailing sub-summary for Gender (3 options) and a sub summary part for Axis 1 disorders (several options). The problem i am having is when i go to preview it is separating the axis 1 and gender options and combining them. E,G,

Instead of having:

Gender 'Male' Count '2'

Gender 'Female' Count '1'

Axis 1 'Dementia' Count '1'

Axis 1 'Substance abuse' Count '2'

It gives me:

Gender 'Male' Count '2'

Axis 1 'Dementia' Count '1'

Axis 1 'Substance Abuse' Count '1'

Gender 'Female' Count '1'

Axis 1 'Substance Abuse' Count '1'

Gender 'Female' Count '1'

Why is this and can i prevent this happening?

Thanks,

Anna

[Vaughan]

Maybe they need to be on separate summary reports.

A lot depends upon how your data is setup and what you want to achieve.

[AnnaC]

I have a database full of info on people. I want to be able to produce a report that summarises some of this info on a printable page from a found set of records.. E.g I want to know the number of males and females, the number of people with certain disorders etc. All of this info would be extracted from fields with value lists. Essentially i am trying to produce a report that summarises the selections from specific fields that have value lists attached. I have worked out how to get the selection info from the field but am unable to have it all appear in the order i want on one layout.

If i use separate summary reports wouldn't this put each set of info on a separate page?

[cjaeger]

you could use the sum() function with relations.

or insert the data into globals via script.