Novice question for derived vars for v. 4.2.2

[MDJ2005]

I'm a complete novice to reportsmith (change in HR staff!). I am trying to add three fields together and having a heck of a time. It is in the ADP database and the three fields (on the standard Hours report) are CHECKVIEWREGHOURS + CHECKVIEWOTHOURS + CHECKVIEWHOURSAMT.

I'm using the derived field tool but find that only the report only picks up a value if all of the values exist. If any one is null then no value prints at all. Any help would be greatly appreciated.

 

[Atrzy]

What is the derived field you wrote that isn't working?

 

[MDJ2005]

The field is set up as TotHrs and the formula in the derived field creation dialog is currently REPORTS.V_CHK_VW_EARNINGS.CHECKVIEWOTHOURS + REPORTS.V_CHK_VW_EARNINGS.[[Reg_Hours]]

Although all records have a Reg_Hours value, the TotHrs only displays a value if both fields have values.

 

[CharlesCook]

If you are using an Oracle DB try this

NVL(REPORTS.V_CHK_VW_EARNINGS.CHECKVIEWOTHOURS,0) + NVL(REPORTS.V_CHK_VW_EARNINGS.[[Reg_Hours]],0)

Any number + NULL = NULL

SEE:

http://www.techonthenet.com/oracle/functions/nvl.php

CharlesCook.com
ADP - PeopleSoft - SAP
ReportSmith - Crystal Reports - SQR - Query - Access
Reporting - Interfaces - Data Mining