Grouping problem?

[mshimonek]

I think this is probably a simple matter but I can^t figure out what I am doing wrong. I have two tables to hold independence information for my acct. firm. The first, Data, contains employee information, relatives that work for clients, clients you have the authority to sign documents for, etc. The second table contains a list of loans that our employees have with clients. ____Example:____Data:__[ssn][Relative][Signature]____Loans:__[ssn][Client][Collateral]____Each employee will have one data record and may have any number of loan records. I am trying to write a report that will display ssn, relative information, all loan information, then signature information. I have tried creating a view that links the tables using ssn then grouping on ssn and loans within r&r but I only see the first loan. Any help you can provide will be much apreciated.__

[kfleming]

Make sure that the loan info is placed on a record band on the report layout.____Kathleen__R&R Support

[rickwjohnson]

I would also make sure (it is easy to overlook) that it is a 1 to many scan, not 1-1.__Rick Johnson__

[mshimonek]

I am grouping on ssn and loans. My loan information is on the loans band line. I only see one loan per employee. ____My resulting view contains multiple records for those individuals with multiple loans. Is this what is meant by one-two-many scan?__

[mshimonek]

I was grouping on lender. This was causing problems with employees who have multiple loans with the same lender. Creating a unique LoanID field and grouping on that solved the problem. Is it necessary for a field to always be unique for R&R to be able to group on it?

[kfleming]

A group break will print any time the value in that field changes.__So what matters is how the records are sorted to determine when a group break will occur.__So records in order__A__A__B__B__will have two group breaks but records__A__B__A__B__will have four group breaks.______Kathleen__R&R Support