Search:

I will still need to group by the gen.loan_num because I am counting the loans later on in the report
So I need to grab the username from the samerow of data where I am getting the max(changedate)
...

Wasnt able to PM you. Email me a screenshot of your version of Crystal and I should be able to help you out. email to j a k e @ d m r - r e p o r t i n g .com - remove all spaces

I have a DB where the 'translog' table has a many-to-one relationship with 'gen'. I am trying to get the 'UserName' to pull from the corresponding line that is giving me the...

Thank you so much, this worked great!

Clarification: 'Customer' and 'Region' are two different fields.
So I do not need them split up- I just need the Regions on one line seperated by Commas.

I have a DB with a many-to-one relationship and I would like the 'Many' to be on one line.

In the example below Smith is a single Customer and is part of 4 regions.
Now:
Customer ...

I have a CR XI which is pointing to an existing SQL database I used to create the report- using ODBC for the connection.
I need to have another person run this CR but its on a different database....