Customer Employee Product

[NewToCR]

Problem again...
Data is like this

Customer Employee Product
1 A X
1 A Y
1 A Z
1 B X
1 B Z
1 C Y

I want to have
Customer as a Page Header
I need to display Employees of this Customer and Products that Customer buys.
So Employee would be A,B,C
Product X,Y,Z regardless...
It is Report to view Customer Profile.

Customer 1
Has 3 Employee A
B
C
Poducts uses X
Y
Z

Thanks

 

[lbass]

The simplest approach would be to group on customer, checking "Repeat group header on each page". Then place the employee ID in the detail section. In the group footer, place a subreport that it linked to the main report on customer and which contains the product field in the detail section.

Another approach would be to accumulate the products in a variable in the detail section for display in the group footer.

-LB

 

[NewToCR]

I was hoping to get by without sub...
How do I 'accumulate'?

Thanks

 

[IdoMillet]

To do this without subreports, simply insert CrossTabs.

Cheers,
- Ido

Visual CUT & DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com