Help with groups 1

[Pete271]

I'm using Crystal 8.5

I have a simple report that has groups and the sub totals of the donations received as well as the status of the gift.

Example

Received Pledged Target

Individuals £100,000 £250,000 £500,000
Corporations £50,000 £45,000 £100,000
Trusts £250,000 £500,000 £1,000,000
----------------------------------------------------
Grand Total £400,000 £795,000 £1,600,000
----------------------------------------------------

The issue I'm having is that a director has requested that as some of the Individual gifts are Legacies and not "money in the bank" they would like them displayed seperately, but in the same report.

I have another table that shows 'Gift Type' that would enable me to identify the Legacy gifts but how do I do this while still maintaining the groups and just adding one more line?

The ideal result would be

Received Pledged Target

Individuals £100,000 £250,000 £500,000
Legacy £50,000 £1,000,000 £2,500,000
Corporations £50,000 £45,000 £100,000
Trusts £250,000 £500,000 £1,000,000
----------------------------------------------------
Grand Total £450,000 £1,795,000 £3,100,000
----------------------------------------------------

 

[dgillz]

Assuming that 'individuals', 'corporations' and 'trusts' are values of a certain field that you are already grouping by (I will call this donor type) write a formula:

If{GiftType}="Legacy" then "Legacy" else {DonorType}

The group by this formula, rather than bu the database field you are currently using.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry

 

[Pete271]

Thank you.

Brilliant!