One-to-Many

[radhak]

I have two files.____One has details of the customer and the other has the orders placed by each of the customers. ____I need to write a report which should look like the following____Cust Name---Address-----Tel-------E-mail-------- Last order__ xxxxx xxxxx xxxx xxxxxxxxxxxxx xxxxxx__ __ Order Number-------- Order total__ xxxxxxxx 999999999__ xxxxxxxx 999999999__ xxxxxxxx 999999999____ xxxxx xxxxx xxxx xxxxxxxxxxxxx xxxxxxx____ Order Number-------- Order Total__ xxxxxxxx 999999999__ xxxxxxxx 999999999______Surprisingly, if I do a One-to-many scan on the customer number as index, R&R report produces a report which repeats the entire customer details for each valid order record found in the order file.____I am new to R&R version 9.0 and I am completely stumped by this as any report writer should be able to do this basic report. But, for R&R it seems to be almost impossible. I may be wrong and if so prove me wrong by giving a solution for this. My report is outstanding becuase of this.____Immediate response is appreciated.__

[kfleming]

You need to use Database Group Order to set customer as a group field.__Then on your report, move the information that needs to print once per customer to a customer group header band.____Kathleen__R&R Support

[radhak]

>You need to use Database Group Order to set customer as a __>group field. __>Then on your report, move the information that needs to __>print once per customer to a customer group header band. __>__>Kathleen __>R&R Support ____Thanks Kathleen. I will try it and get back to you. I hope this works.____Am I correct in saying the following:____Treat the individual records in the customer database as group and move all the info from the customer datatbase to the Group Header and on the record band give the order details. Am I to have one-to-many as scan?____Further if I am to have another file also on one-to-many to be printing for each customer record, how do I get about doing it? I mean along with the orders, if I am to include the customer preferences (more than one) for each customer. These preferences are also included in another database, which is again on a one-to-many relationship.____Would appreciate your immediate response.____