I am working on a report that runs a query based on a to/from date.  It prints out a line of detail but a memo field contains 2 different notes for each line of detail.  If the number of days selected is 10, Crystal prints out 20 lines of detail, 1 line for each date, 1 line for each for each note.  What I would like to do is print one line of detail for each but if I try and summarize on the Group Footer section of the file, only the first memo line prints out.  Any suggestions for working around this?  I was thinking of creating a User Defined Function to concatenate the data onto one line but am unsure how to proceed.  Any suggestions?

As always thanks very much

Chuck Hartford

Sorry for not being a little more clear

This is what I currently have:
McConnell Hall    659    109    also added this note on as well just to see what happens.    Saturday, February 1, 2014    Saturday, February 1, 2014
McConnell Hall    659    109    Test Text can go here while the room is blocked off.  Once the room is unblocked then this Note can be deleted.  The Note can also be quite large.    Saturday, February 1, 2014    Saturday, February 1, 2014
McConnell Hall    659    109    also added this note on as well just to see what happens.    Sunday, February 2, 2014    Sunday, February 2, 2014
McConnell Hall    659    109    Test Text can go here while the room is blocked off.  Once the room is unblocked then this Note can be deleted.  The Note can also be quite large.    Sunday, February 2, 2014    Sunday, February 2, 2014

If I could get to something like this:

Building_Name    Building_Number    Room_Number    Notes    Start_Date    End_Date
McConnell Hall    659    109    also added this note on as well just to see what happens.    Saturday, February 1, 2014    Saturday, February 2, 2014
McConnell Hall    659    109    Test Text can go here while the room is blocked off.  Once the room is unblocked then this Note can be deleted.  The Note can also be quite large.    Saturday, February 1, 2014    Saturday, February 2, 2014

I'm not trying to summarize on anything but wasn't sure of the best method for reducing the amount of data in a line of text so I thought if I could insert the Notes field in a Group Footer and then suppress the line detail but it doesn't work.  I only get one line of text, from the Notes field, where 2 lines should exist.
I'd also like to get the start and end date on the same line regardless of how many detail lines are brought back.

Thanks for the solution. Me and a coworker tried your solution but added a 4th group level based on the memo field. That's done the trick. Thanks for pointing the way.