Grouping within a Report

[Guest]

I'm trying to create a report that prints customers grouped by first letter
of their name. I was using the left function to return first character of
product names, but instead of getting the desired "grouping" effect (the
letter "A" followed by each customer who had a name beginning with the letter
"A") each was showing up ungrouped (the letter would appear above each
customer, with the letter appearing multiple times).

WHAT I USED: =Left([chrCustName],1)
WHERE I PUT IT: In the chrCustName Header. All other fields were in the
details section.

Any help you can offer would be greatly appreciated!

 

[Marshall Barton]

I'm trying to create a report that prints customers grouped by first letter
of their name. I was using the left function to return first character of
product names, but instead of getting the desired "grouping" effect (the
letter "A" followed by each customer who had a name beginning with the letter
"A") each was showing up ungrouped (the letter would appear above each
customer, with the letter appearing multiple times).

WHAT I USED: =Left([chrCustName],1)
WHERE I PUT IT: In the chrCustName Header. All other fields were in the
details section.

You need to set the group's field/expression (in Sorting and
Grouping window) to:

=Left(chrCustName,1)

instead of the chrCustName field.

 

[Guest]

That worked perfect - thanks!!!
--
- Jennifer

I'm trying to create a report that prints customers grouped by first letter
of their name. I was using the left function to return first character of
product names, but instead of getting the desired "grouping" effect (the
letter "A" followed by each customer who had a name beginning with the letter
"A") each was showing up ungrouped (the letter would appear above each
customer, with the letter appearing multiple times).

WHAT I USED: =Left([chrCustName],1)
WHERE I PUT IT: In the chrCustName Header. All other fields were in the
details section.

You need to set the group's field/expression (in Sorting and
Grouping window) to:

=Left(chrCustName,1)

instead of the chrCustName field.