Records Excluded By Group

[product26]

I am working on a report consisting of a bunch of running totals. The report is breaking down entries in our database by type, giving a subtotal, and then detailing that by source.

It is broken down by rep (the person who gets credit for the entry). This is done by putting the running totals in the rep group.

My problem is that for one of the totals, I need to show everything that was entered by each rep, that they do not get credit for (that they are not listed as the rep). But it seems that because they are in the rep group, it already excludes the records that I need, therefore they cannot be counted in the running total.

How would I get around this problem?

 

[Madawc]

If you need to group the same data in two different ways, see if you can use a Crosstab. Failing this, you'll need to use a subreport, placed in the report header or footer. Note that you can base your subreport on the existing report, using Save As to create a copy and then importing it as a subreport.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[lbass]

Please provide your exact group structure, naming the groups.

Is the summary you want per rep for what they don't get credit for per a certain group? You could potentially use a formula something like this:

distinctcount({table.entryID},{table.higherordergroup})-{#repcredit}

-LB

 

[product26]

After 'sleeping on it' i came back today and approached it with a clear mind.

I was able to determine that I could group by another field. We have different fields that have similar data. For each user there is a user name, a name, and initials. So I am sorting by name, and breaking it down by user name.

lbass, it was your request for the exact group structure that made me question the grouping. Thank you for sparking that thought in my mind.


Thank you!