report question - should be easy

[paulmetzger]

I'm doing some porting from Q&A 4 to FileMaker Pro 6 and am having trouble duplicating a report

in Q&A I have this:

Category	SubCategory	SubSubCategory

I		a		1

				2

		b		11

				12

II		c		21

				22

III		e		41

		f		51

				52

In FMP I get

Category	SubCategory	SubSubCategory

I		a		1

I		a		2

I		b		11

I		b		12

II		c		21

II		c		22

III		e		41

III		f		51

III		f		52

Will FMP do what Q&A does? I messed with the "report with grouped data" in the report wizard and the resulting subsummary parts, but I can't make it look like I want.

Thoughts?

[LiveOak]

For subsummaries to view correctly:

1) The records must be sorted by Category/SubCategory/SubSubCategory

2) You must go to Preview mode (or print) to see the report.

Your layout needs:

1st Subsummary when sorted by Category

2nd Subsummary when sorted by SubCategory

3rd Subsummary when sorted by SubSubCatetory

This will give you something like you want:

I

a

1

2

II

b

11

12

To put all on one line takes some playing around with self-relationships.

-bd