DF-M22102-Wealth Engine total years giving calculation returns 0 value

Submitted by 334 on
Symptom
The Wealth Engine total years giving calculation returns a 0 value.

WealthEngineInfo.totalYearsGiving

Millennium does pass what I would think is total years giving, always passed as 0.  We do not calculate it.
       WealthEngineInfo.totalNumberGiving = 0;
       WealthEngineInfo.totalNumberGivingSpecified = false;
The WealthEngineInfo.totalYearsGiving comes from this select and additional logic, works like consecutive year in totals utility.
                                SELECT gifteffdat
                                                FROM (
                                                                SELECT gifteffdat
                                                                                FROM gifts
                                                                                WHERE giftid = 'xxxxxxxxxx' and (gifttype = 'p' or gifttype = 'e' or gifttype = 'sp')
                                                                UNION
                                                                SELECT gifteffdat
                                                                                FROM gifts
                                                                                WHERE giftid = 'xxxxxxxxxx' and gifttype = 'g')
                                                AS temp
                                                ORDER BY gifteffdat ASC
**If the current year is greater than or equal to year from the select above then current year – year retrieved otherwise set to 0.
 
gifteffdat
2011-12-20 00:00:00.000
2014-03-10 00:00:00.000
2014-10-30 00:00:00.000
2014-12-02 00:00:00.000
2014-12-11 00:00:00.000
2016-02-02 00:00:00.000
2016-02-26 00:00:00.000
2017-01-27 00:00:00.000
 
 
Product Line

DF-M22097-Most recent gift date for the largest gift should be returned by Wealth Engine select when multiple gifts with the same amount exist

Submitted by 334 on
Symptom
Wealth Engine largest gift is randomly selecting the largest amount in the case where there are two gifts of the same amount.  The date is converting to character and not sorting as a date field, therefore not returning the most recent largest gift.


Product Line

DF-M21969-Sustainer pledges and payments deleted if user clicks OK to cancel the entire transaction without saving payment information

Submitted by 334 on
Symptom
Sustainer pledges and payments deleted if user clicks OK to cancel the entire transaction without saving payment information after receiving a message about the status of the credit card.
Product Line

Photos in on demand or yellow button reports do not display properly

Submitted by 334 on
Symptom
Photos in on demand or yellow button reports do not display properly.

One of the standard Crystal formats available as a profile report (a.k.a. yellow button report) is the biographical summary with photo.

It is creating a PDF as it should, but the photo is either squished or stretched to fit the space.  Crystal is finding the photo but then distorting it.

Product Line