sort order problem

[Guest]

I have a report that is sorted by primary borrower. Beneath each primary
borrower is a list of items for the primary borrower and for any guarantors
for that borrower. This field is called "customer" and is sorted
alphabetically. For each primary borrower there is a risk rating.

I want the risk rating to display in my header row for primary borrower.
However, when the first alphabetical customer is a guarantor, they don't have
a risk rating, and no risk rating appears in the header row, even though the
primary borrower does have a risk rating. If the primary borrower's name is
first in the list of customers, then the risk rating displays in the header
row.

How can I make the risk rating always display, even if the guarantor comes
first alphabetically? I don't care what order the customers appear in, but I
don't know how to change it.

Thanks!

 

[Joseph Meehan]

I have a report that is sorted by primary borrower. Beneath each
primary borrower is a list of items for the primary borrower and for
any guarantors for that borrower. This field is called "customer"
and is sorted alphabetically. For each primary borrower there is a
risk rating.

I want the risk rating to display in my header row for primary
borrower. However, when the first alphabetical customer is a
guarantor, they don't have a risk rating, and no risk rating appears
in the header row, even though the primary borrower does have a risk
rating. If the primary borrower's name is first in the list of
customers, then the risk rating displays in the header row.

How can I make the risk rating always display, even if the guarantor
comes first alphabetically? I don't care what order the customers
appear in, but I don't know how to change it.

Thanks!

How are these arranged and related in table(s)?

 

[Guest]

Each is brought in from a report from another database; primary, customer,
and risk rating are all fields in the same table.

 

[Joseph Meehan]

Each is brought in from a report from another database; primary,
customer, and risk rating are all fields in the same table.

Well I guess that is beyond me. I don't know how you can take data from
a report in another database for a report in the local database. Assuming
you can, I have no idea of what kind of form the data would be in.