I have a report that has a subreport on it.  The subreport has 2 groupings -

Grouping1 and Grouping 2.  Grouping2 records are in the detail section.  In

the Grouping1 footer, I take a total of all of the records in Grouping2.

This works great.



The problem I have is this.  On the main report, I have the subreport in the

detail section.  I need totals of the different sets of records in Grouping1

on the subreport.  I'm not sure if I am saying this correctly.  Let me draw

how the report should look.



*************

'How it should look



Main Report Detail



	Subreport Grouping1.1.1



		Subreport Grouping2.1

			Record1

			Record2

			Total

		Subreport Grouping2.1

			Record1

			Record2

			Total

	Subreport Grouping1 Total (This is the total of the Grouping2 totals)



	Subreport Grouping1.1.2



		Subreport Grouping2.1

			Record1

			Record2

			Total

		Subreport Grouping2.1

			Record1

			Record2

			Total

	Subreport Grouping1 Total (This is the total of the Grouping2 totals)



Total of Grouping1.1 (from the subreport)



	Subreport Grouping1.2



		Subreport Grouping2.1

			Record1

			Record2

			Total

		Subreport Grouping2.1

			Record1

			Record2

			Total

	Subreport Grouping1 Total (This is the total of the Grouping2 totals)



Total of Grouping1.2 (from the subreport)

************





************

'How it looks



Main Report Detail



	Subreport Grouping1.1.1



		Subreport Grouping2.1

			Record1

			Record2

			Total

		Subreport Grouping2.1

			Record1

			Record2

			Total

	Subreport Grouping1 Total (This is the total of the Grouping2 totals)



	Subreport Grouping1.1.2



		Subreport Grouping2.1

			Record1

			Record2

			Total

		Subreport Grouping2.1

			Record1

			Record2

			Total

	Subreport Grouping1 Total (This is the total of the Grouping2 totals)



Total of Grouping1.1 + Grouping1.2 (from the subreport)



	Subreport Grouping1.2



		Subreport Grouping2.1

			Record1

			Record2

			Total

		Subreport Grouping2.1

			Record1

			Record2

			Total

	Subreport Grouping1 Total (This is the total of the Grouping2 totals)



Total of Grouping 1.1 + Grouping1.2 (from the subreport)

************



I can get a grand total of all of the totals from Grouping1, ie, Grouping1.1

+ Grouping 1.2 to appear in the totals field on the main report on every

section.  However, I am not able to break it out by detail records, ie, a

different total for all of Grouping 1.1 and a different total for

Grouping1.2 that prints at the end of each detail section.



I'm sorry if this is confusing, so if you need more detail please ask.  Any

help would be greatly appreciated.



John Pace

Manager of Information Technologies

Haws and Tingle General Contractors

650 West Vickery Blvd

Fort Worth, TX  76104

xxx-xxx-xxxx

Fax:   xxx-xxx-xxxx

E-Mail:  jpace@h...

www.hawstingle.com