Horizontal Details

[jrcol12357]

CR XI, I need to layout a report that will have multiple fees and fee names. My customer wishes to display the information horizontally. Each record would bring back a different amount of names and fees. Example 1st loan may have 5 fees and 5 fee names, the next loan could have 10 fees and 10 fee names.
Loan Num, fee name_1, fee_1, fee_name_2, fee_2

Displaying this in a regular vertical format is no problem.
Loan Num,
fee name1, fee1
fee name2, fee2
fee name3, fee3
fee name4, fee4

 

[PatriciaObreja]

Watch also this topic:

http://www.tek-tips.com/viewthread.cfm?qid=1447134&page=1

So you need to group records by Loan Num, then create a formula that will be placed in group header, and another formula for details section.

You will suppress the Details, and will place the result in group footer.

 

[jrcol12357]

Thank you, I'll try it out