Jump to content
Sign in to follow this  
AnnaC

Separating sub-summary parts

Recommended Posts

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

Share this post


Link to post
Share on other sites

Maybe they need to be on separate summary reports.

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

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites

you could use the sum() function with relations.

or insert the data into globals via script.

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.