Get different amounts total in one line? 1

[AuctionLamb]

Hi guys!!

I have 3 records with different Processed Dates, but with the same GLCode "100-10-52-22". These 3 records also has 3 different Amounts. How do I get all of this into one line?

I have grouped ProcessesDate by Month, and want to show ONLY 1 GLCode and one Total field(want to add the different amounts like in a total). When I dbl_click on the GLCode I want show the detail of that total(three Totals that made it up) and the exact 3 dates for that GLCode. How can this be done?

Can you guys sort me out? Help please....this report is quite important.

Thanks!!!

 

[Madawc]

Group by GLCode as well, but within month. (That's assuming you don't also want to group outside of months. If you do, you'll probably need a subreport, which is an inefficient solution.)

Madawc Williams (East Anglia, UK)

 

[kenhamady]

Group by GL Code and add a subtotal of the amount for each GL Code. "Hide" the details that ocntain the date and the group header.

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Tips and Tricks / Guide to Crystal in VB

http://www.kenhamady.com/

- TEK2(AT)kenhamady.com

 

[AuctionLamb]

Thanks!! Works cool!