Getting field data from summary report

[Quang]

Hi, I'm kind of a newbie to the summary report so I need some help on this matter.

I created a summary report that looks like this in preview mode:

Shop Revenue

-----------------------------------

Glass Shop

$100

$200

--------

Total $300

------------------------------------

Machine Shop

$200

$300

--------

Total $500

------------------------------------

Wood Shop

$100

$100

----------

Total $200

---------------------------------------------

Grand Total $1,000

How do I go about getting each of those "Shop" total into a field?

Example: g_Field1_Glass=$300

g_Field2_Machine=$500

g_Field3_Wood=$200

[comment]

I think you have three options here, in increasing order of complexity:

1. Produce a similar report, but leave only sub-summaries by shop on the layout (i.e. delete the body part of the report layout);

2. On a layout of shops, show an aggregate calculation of shop's related revenues (this depends on whether it's possible to filter the relationship to get a related set similar to your found set);

3. Study this method:

http://www.onegasoft.com/tools/fastsummaries/index.shtml

[Quang]

Thanks,

The 2nd option gave me what I wanted and was the quickest route.

Thanks.