Show subsumarry of each record subtotal !

[Anh_Tran]

I would like to do like this

REgion Name Total sale

A

John 20

Paul 10

------

30

I create part like ...

Subsummary by REgion ( leading)

body

Subsumarry by REgion (trailing)

But it only works in Preview mode? ...If I want to do like above in Browse Mode? Do you have any idea how to do it in Browse mode?

Thanks

[Anh_Tran]

I view as a form on browse mode ..it works ...but view as a list on Browse mode ..it does not work.

But in Preview mode it works? No idea how to fix it if I want to see as a list on Browse mode

thanks

[LiveOak]

Subsummaries can't be viewed in Browse mode. They are also dependent upon sort order. If the sort order is incorrect, they won't show in Preview mode either. To gain subsummary information in Browse mode, you must use relationships and the Sum() function. This is usually only practical for summarizing by, for example, one company at a time. Subsummaries are really a printed report function.

-bd

[BobWeaver]

I've set up a system based on Captkurt's idea of going into preview mode and copying the preview. The script does this:

# Script PasteReport

-Go to preview mode

- Go to the report layout that has the summary parts

-Go to page based on global field gPage

-copy

-go to browse mode

-go to a layout that has a global container field that covers the whole layout

-paste the picture into the container.

This layout also has two buttons: forward and backward

The forward button executes the following script

Set field gPage = gPage+1

Perform script PasteReport

The backward button executes the following script

Set field gPage = gPage-1

Perform script PasteReport

These allow you to page through the report.