Single group header based on multiple fields

  • Thread starter Thread starter AndyK
  • Start date Start date
A

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!
 
AndyK said:
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?
Click to expand...


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
 
Thats exactly what I needed - thanks!

Marshall Barton said:
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
Click to expand...
 
Marshall Barton said:
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
Click to expand...

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
 
Jonas said:
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.
Click to expand...


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".
 
Back
Top