Hello,

A colleague of mine and I are working on the same report.  When I view the report, two of the fields that calculate a max value do not calculate but they do calculate for him.  The fields are expected and potential impact.

Here's what I see -


Here's what he sees -


I refresh the report data and the timestamp and other report data is updated and correct, but these two fields do not calculate.

We are both using Crystal Reports 10 and the same MySQL ODBC Driver.

Here is the SQL query -

 SELECT `MASTER1`.`mrID`, `MASTER1`.`mrTITLE`, `MASTER1`.`mrSTATUS`, `MASTER1`.`mrURGENT`, `MASTER1`.`mrSUBMITDATE`, `MASTER1`.`HSI__bPotential`, `MASTER1`.`Telephony__bPotential`, `MASTER1`.`Video__bPotential`, `MASTER1`.`HSI__bActual`, `MASTER1`.`Telephony__bActual`, `MASTER1`.`Video__bActual`, `MASTER1`.`Potential__bCustomer__bImpact__Q`, `MASTER1`.`Actual__bCustomer__bImpact__Q`, `MASTER1`.`Affected__bSite`, `MASTER1`.`Supported__bBy`, `MASTER1`.`Urgency`, `MASTER1`.`Desired__bStart__fEnd__bDate`, `MASTER1`.`Desired__bStart__fEnd__bDate__bLink`, `MASTER1`.`End__bDate__fTime`, `MASTER1`.`End__bDate__fTime__bLink`, `MASTER1`.`Is__bthis__ban__bemergency__brequest__Q`, `MASTER1`.`Actual__bStart__bTime`, `MASTER1`.`Actual__bComplete__bTime`, `MASTER1`.`mrDESCRIPTION`, `MASTER1`.`Nodes__fDevices__bAffected`, `MASTER1`.`Louisville__bImpact`,
CASE WHEN `MASTER1`.`Is__bthis__ban__bemergency__brequest__Q`='Yes' then 'Emergency' else 'Scheduled' END as type,

`MASTER1`.`Is__bthis__ban__bemergency__brequest__Q`,
CASE    
        WHEN     `MASTER1`.`HSI__bPotential`>= `MASTER1`.`Telephony__bPotential` AND
            `MASTER1`.`HSI__bPotential` >= `MASTER1`.`Video__bPotential` THEN
            `MASTER1`.`HSI__bPotential`
        WHEN     `MASTER1`.`Telephony__bPotential` >= `MASTER1`.`HSI__bPotential` AND
            `MASTER1`.`Telephony__bPotential` >= `MASTER1`.`Video__bPotential`THEN
            `MASTER1`.`Telephony__bPotential`
        WHEN    `MASTER1`.`Video__bPotential`>= `MASTER1`.`HSI__bPotential` AND
            `MASTER1`.`Video__bPotential`>= `MASTER1`.`Telephony__bPotential` THEN
            `MASTER1`.`Video__bPotential`
            ELSE 0
        END AS MAXPOTENTIAL,
CASE    
        WHEN     `MASTER1`.`HSI__bActual`>= `MASTER1`.`Telephony__bActual` AND
            `MASTER1`.`HSI__bActual` >= `MASTER1`.`Video__bActual` THEN
            `MASTER1`.`HSI__bActual`
        WHEN     `MASTER1`.`Telephony__bActual` >= `MASTER1`.`HSI__bActual` AND
            `MASTER1`.`Telephony__bActual` >= `MASTER1`.`Video__bActual`THEN
            `MASTER1`.`Telephony__bActual`
        WHEN    `MASTER1`.`Video__bActual`>=  `MASTER1`.`HSI__bActual` AND
            `MASTER1`.`Video__bActual`>=  `MASTER1`.`Telephony__bActual` THEN
            `MASTER1`.`Video__bActual`
            ELSE 0
        END AS MAXACTUAL,
DATE_FORMAT(`MASTER1`.`Desired__bStart__fEnd__bDate`,'%l:%i %p')  AS STIME,

REPLACE(REPLACE( `MASTER1`.`Affected__bSite`, '__b', ' '),'__u','-')  AS SYSTEM,
SUBSTRING(REPLACE(REPLACE( `MASTER1`.`mrTITLE`,''','') ,'’','`'),1,50) AS REASON,

REPLACE(`MASTER1`.`Supported__bBy`,'__b',' ' )  AS SUPPORTEDBY,

Replace(REPLACE(`MASTER1`.`mrSTATUS`,'__b',' '),'__u',' ') as STATUS,

REPLACE(REPLACE(`MASTER1`.`Louisville__bImpact`,'__b',' '),';','\r')  as LOUISVILLEIMPACT

 FROM   `MASTER1` `MASTER1`

WHERE Date(`MASTER1`.`Desired__bStart__fEnd__bDate`) >= Date(INTERVAL 1 DAY + curdate())

Please help if you can!

Thanks,

Brian

Thank you, lockwelle - I will take the steps that you suggest.