Hello. First post. Be gentle.

I'm totally flummoxed by Sub Summary Reports.

I am trying to create a report that will list/print summary totals for a database membership based on two fields [area] [reference]. There is also a unique field

 should it be required. 

Something like the following... (I hope the formatting comes out ok)

area 11

reference Total

W10 52

w11 128

w12 29

...

w20 77

area 12

n10 55

n11 217

...

n49 59

area 13

p22 84

p23 111

area 14

etc.

I realise this is a pretty basic type of report, but at the moment it is beyond me.

Thanks John

Not sure where to start....

create 'sub-summary when sorted' parts that lie above your data. Put the area and reference fields into them.

Go to Browse and sort by area and reference.

Enter Preview Mode to see how it will print.

Hope this is what you were asking about.

Cheers,

It must be me.

I just want to group by 'Area' i.e just show 'Area' once per Area, then let the report show,

 

area 11



reference      Total

W10                 52

w11                 128

w12                 29             etc.,

 

('Total' is a Summary Field = Count of Reference)

Thanks for the help though, it's appreciated. No one else even bothered to say 'hello', 'welcome' or indeed offer any attempt at guidance/criticism/support or even derision.

John

It looks like you need two subsummary parts, one by 'area' and one by 'reference'. The subsummary by 'reference' will need to be positioned underneath the one by 'area'. Put your 'area' field in the first subsummary and your reference and Total fields in the second one. You can then remove the body part, if you currently have one, sort by area, reference (in that order), and enter Preview Mode.

You can then create a script to perform the same sort and preview steps for future reference.

Note that the same thing can be done by selecting Layouts -> New Layout/Report - Columnar list/report, in Layout Mode. The Wizard will guide you through creating the subsummaries and offer to create a script automatically.

>>> .... and enter Preview Mode . <<<<

I think that was a part of my confusion. I tended to look at Browse Mode.

Thank you both. It now works as I need it to.

I would like to add a further step though!

I would like the user to be able to enter an 'Area' number, so that only that specific area gets previewed/printed. I don't know if this should be a seperate topic. Any help would be appreciated.

John

It sounds like a simple find script. There are several examples of find scripts floating around here. Try searching the 'Finding & Searching' forum first. Then post there, if you still need help.