Multiple fields at same grouping level in report wizard

[Amy Blankenship]

I often have a query that is being used as the data source for a report with
multiple fields from the same record at each grouping level. So, for
instance, I might have

CategoryID, CategoryDesc, TopicID, TopicDesc, TopicOrder, PageID...

The desired report design is:

CategoryDesc

TopicOrder TopicDesc

Page...

So it would be really nice if I could just include both the topic order and
description in the same grouping level in the wizard, rather than having to
manually move it _every_ time. I've tried using control, alt, and shift
(not together) to extend the selection to allow me to do this, but it
doesn't work. Is there a way to do this, or do I need to just resign myself
to moving things around by hand?

Thanks;

Amy

 

[KARL DEWEY]

For Sorting and Grouping enter CategoryDesc, TopicOrder, TopicDesc, and Page.
But have a header for CategoryDesc, TopicOrder, and Page only.
Place TopicOrder and TopicDesc in the same header.

 

[Marshall Barton]

I often have a query that is being used as the data source for a report with
multiple fields from the same record at each grouping level. So, for
instance, I might have

CategoryID, CategoryDesc, TopicID, TopicDesc, TopicOrder, PageID...

The desired report design is:

CategoryDesc

TopicOrder TopicDesc

Page...

So it would be really nice if I could just include both the topic order and
description in the same grouping level in the wizard, rather than having to
manually move it _every_ time. I've tried using control, alt, and shift
(not together) to extend the selection to allow me to do this, but it
doesn't work. Is there a way to do this, or do I need to just resign myself
to moving things around by hand?

One more of the issues you'll have using the wizard for a
nontrivial report. Time for you to graduate to working in
design view where wizards won't get in the way.

 

[Amy Blankenship]

One more of the issues you'll have using the wizard for a
nontrivial report. Time for you to graduate to working in
design view where wizards won't get in the way.

The wizard makes sure all the reports have the same format without my having
to remember what font and size to use where. This saves more time than
fixing a less than adequate report takes, if it can't handle this.

Thanks;

Amy

 

[Marshall Barton]

"Marshall Barton" wrote

The wizard makes sure all the reports have the same format without my having
to remember what font and size to use where. This saves more time than
fixing a less than adequate report takes, if it can't handle this.

You will either have to fix up the report in design view or
live with the the limitations of the wizard.

Have you looked into using a template report to get a
consistent format?

 

[Amy Blankenship]

You will either have to fix up the report in design view or
live with the the limitations of the wizard.

Have you looked into using a template report to get a
consistent format?

I thought the wizard was the way to do that.

Thanks;

Amy

 

[Marshall Barton]

I thought the wizard was the way to do that.

You use an existing report (however you initially created
it) as a template by using Tools - Options - Forms/Reports

Using a wizard presumes that you do **not** want to use a
template.

Check Help for:
Default Template
About using a template to create

 

[Amy Blankenship]

You use an existing report (however you initially created
it) as a template by using Tools - Options - Forms/Reports

Using a wizard presumes that you do **not** want to use a
template.

Check Help for:
Default Template
About using a template to create

OK, thanks