Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Novice question for derived vars for v. 4.2.2

Status
Not open for further replies.

MDJ2005

Technical User
Aug 31, 2005
7
US
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.

 
What is the derived field you wrote that isn't working?
 
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.
 
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:
CharlesCook.com
ADP - PeopleSoft - SAP
ReportSmith - Crystal Reports - SQR - Query - Access
Reporting - Interfaces - Data Mining
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top