Multiple Groupings in report

[Guest]

Hi,

I have a report that is based on a query. This query has two tables with a
relationship. I want the report to have two groupings but cannot get the
data to print correctly. For example, tbl_fruit (group #1) has apples,
oranges, bananas, etc. Group #2 has types of apples, oranges and banans.

So, I want the report to print:

Apples
MacIntosh
Useful information
Granny Smith
Useful information
Red Delicious
Useful Information

page break

Oranges
Navel
Useful information
Tangerines
Useful information
Sweet oranges
Useful information

page break

Bananas
California Bananas
Useful information
Mexican Banans
Useful information
etc.
etc.
etc.

How do I get the report to do this? Note: I am not reporting on fruit but
this is the only example I could think of to explain my problem.

Thanks in advance.

 

[Marshall Barton]

I have a report that is based on a query. This query has two tables with a
relationship. I want the report to have two groupings but cannot get the
data to print correctly. For example, tbl_fruit (group #1) has apples,
oranges, bananas, etc. Group #2 has types of apples, oranges and banans.

So, I want the report to print:

Apples
MacIntosh
Useful information
Granny Smith
Useful information
Red Delicious
Useful Information

page break

Oranges
Navel
Useful information
Tangerines
Useful information
Sweet oranges
Useful information

page break

Bananas
California Bananas
Useful information
Mexican Banans
Useful information
etc.
etc.
etc.

How do I get the report to do this? Note: I am not reporting on fruit but
this is the only example I could think of to explain my problem.

Use Sorting and Grouping (View menu) to create the groups,
first on the fruit field and then on the type field.
Specify that you want group headers for both groups and the
rest should be straightforward,