Single group header based on multiple fields

[AndyK]

hi all

I have a report where a I need a group header and detail sections, but
grouped on a combination of two fields, not just one - can't find a way of
doing this, is it possible?

thanks!

 

[Marshall Barton]

I have a report where a I need a group header and detail sections, but
grouped on a combination of two fields, not just one - can't find a way of
doing this, is it possible?

Depends on what you mean by "combination of two fields"

You can use an expression in the Sorting and Grouping -
Field/Expression cell. So, if your "combination" is
something simple like last name and first name, just group
on an expression like:
=lastname & "," & firstname

 

[AndyK]

Thats exactly what I needed - thanks!

Depends on what you mean by "combination of two fields"

You can use an expression in the Sorting and Grouping -
Field/Expression cell. So, if your "combination" is
something simple like last name and first name, just group
on an expression like:
=lastname & "," & firstname

 

[Jonas Haglund]

Depends on what you mean by "combination of two fields"

You can use an expression in the Sorting and Grouping -
Field/Expression cell. So, if your "combination" is
something simple like last name and first name, just group
on an expression like:
=lastname & "," & firstname

In this case you sort of create a new column based on the values in other
columns - what if you want to group on first name and last name but keep the
values separate in their respective column, i.e. grouping on a group of
columns. Is that possible?

Regards,

jonas Haglund

 

[Marshall Barton]

In this case you sort of create a new column based on the values in other
columns - what if you want to group on first name and last name but keep the
values separate in their respective column, i.e. grouping on a group of
columns.

A sorting and grouping expression has no effect on the
columns in the report's record source table/query. You can
use the same text boxes the same way as if there were no
grouping.

OTOH, it's unclear to me what you mean by "column" or by
"grouping on a group of columns".