Table View and sub-summary fields

[Mikelevich]

New to V6 and enjoying the ease of Table View for some situations. But it seems to not recognise sub-summary fields - that is they don't show in Preview. Is this the case? That means it's either re-sizable and movable columns and no sub-summaries - or sub-summaries in a list without the joys of movable columns.

I think I know the answer to this, but I'd just like someone to confirm it.

thanks

[Oldfogey]

Have you tried GetSummary? (I haven't tried because I don't use Table View.)

[Mikelevich]

No - because this isn't for a calculation, but for a sort. In other words I need to sort (as a sub-summary) on particular fields - ie: if there are two teachers each with a number of students, then I want to end up with a list of teacher one, with all his students, followed by teacher two with his, etc. - the sort would be on 'teacher' in the sub-summary part.

But perhaps there's another way to do it?...

thanks

(oh, and hi to a fellow aussie)

[The Shadow]

With GetSummary() you specify the "break" field also, in this case your Teacher field.

So you could create a summary, "NumStudents" defined as Count(studentName), then create the calculation:

GetSummary( NumStudents, Teacher )

and when the table view is sorted by Teacher, the calculation should be correct.

[Mikelevich]

Thanks Shadow - yes, of course you're right, but that's not what I was looking for. It's not a calculation that's the problem, but a purely visual breakup of the info. ie:

Joe Bloggs (teacher)

jimmy

sue

fred

Jane Doe (teacher)

pete

mary

etc

Does that make sense? It's the kind of visual breakup that's normal with sub-summaries in a sorted list (and obviously I can do it in List View), but that seems to be not possible with Table View. Since the movable columns were so handy in T.V and as I've got a whole load of lists to create, I was kinda hoping I could have my cake and eat it too. But alas....

Thanks for the suggestions

cheers

[The Shadow]

Oh, I see what you want.

No, I don't think that's possible.

[Mikelevich]

No, I didn't think so. Oh well.... back to constructing the old list views - or better still, convincing the users that they really luuurve the way Table View prints out.

thanks again for your suggestions

[Oldfogey]

A bit late BUT ....

you used the magic word 'print'.

You can certainly show what you want in Preview mode if you are game to let your users use the 'Continue' button to print it.

You just can't get what you want in Table or Browse view. (You should be able to mock up a 'normal' layout to look like Table view.)

BTW I think the Aussies are here out of all proportion to our population.