Comparing individual performance to overall average

Hello. I'll begin by stating that I've only been using BusinessObjects Crystal Reports XI for a short amount of time--somewhere around two months. This problem is rather frustrating as I'm sure there must be a more direct means of solving it (i.e. avoiding subreports and hackish workarounds of printtime formula evaluations, etc...)

Briefing: I am connecting to a simple single-element Business View (on top of MS SQL Server). Each record in the view is a trouble ticket handled by my group at work. Using simple date arithmetic, I am able to determine how long it takes for each trouble ticket to go from an open state to a closed state. Naturally, it is crucial to know how quickly these tickets are being resolved.

All is simple, so far. The objective behind the report in question is to analyze how long, on average, one client's tickets take to close against the average for all clients--grouped by fiscal quarter. The company/companies to compare against the overall average are determined by a parameter.

To restate: I have one level of grouping for fiscal Quarter, beginning with 2005 Q1. Under this I need to group by Company, and this needs to be based on the aforementioned string array parameter. The trick is that I also need to preserve the data for all clients while simultaneously isolating the selected customers. The data will be used to make a multi-bar graph.

So...how do I go about grouping and sorting and selecting and whatnot as to achieve my desired effect? As I alluded to above, I feel that there is a convoluted way to approach this problem, and Im looking for some wise soul to inject some wisdom.

Any and all help would be much appreciated.EDIT:

I've solved the problem. If anyone would like to know how, simply ask.sqlsql