Ok for starters I am a Crystal Reports newbie so I hope this is an easy question for someone. I have an income statement report that currently has a detailed list of items for each department. For example:
Salary Expense - Finance 60000-10-1 $11111
Salary Expense - Factory 60000-20-1 $11111
Salary Expense - Welding 60000-25-1 $11111
Employee Training 63500-10-1 $2222
Employee Training 63500-20-1 $2222
Employee Training 63500-25-1 $2222
This is just a small example but basically what I need to accomplish is condensing and totaling these multiple department entries into one. For example:
Salary Expense 60000 $33333
Employee Training 63500 $6666
Now obviously there are a lot more entries but I hope you guys can see where I'm coming from. Also the account number isnt necessary to show up on the report I just figured using it would be the best way to accomplish my goals.
EDIT: Oh and btw the data is being pulled from a .ttx file. Not sure if that matters
Edited by: anthony24 on Apr 15, 2010 3:45 PM