Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Customer Employee Product

Status
Not open for further replies.

NewToCR

Programmer
Oct 20, 2005
54
US
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



 
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
 
I was hoping to get by without sub...
How do I 'accumulate'?

Thanks
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top