Skip to Content
0
Former Member
Apr 15, 2010 at 01:40 PM

help with filtering and totaling parts of a report at the same time

35 Views

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