Derived Fields to pull total hours for different months

[ttrsnoob]

I would like to put together a report that pulls total hours. I would need one dirived field for January and another field for February. Any ideas how I can do this?

Thanks

 

[ttrsnoob]

Here is what I was trying
SELECT
((SUM( DECODE("PS_AL_CHK_HRS_ERN"."ROW_NBR",'2',"PS_AL_CHK_HRS_ERN"."AL_HOURS",0 ) )) + (SUM( DECODE("PS_AL_CHK_HRS_ERN"."ROW_NBR",'1',"PS_AL_CHK_HRS_ERN"."AL_HOURS",0 ) )) + ( SUM( DECODE("PS_AL_CHK_HRS_ERN"."ERNCD",'H',"PS_AL_CHK_HRS_ERN"."AL_HOURS",0 ) ) ) + (SUM( DECODE("PS_AL_CHK_HRS_ERN"."ERNCD",'I',"PS_AL_CHK_HRS_ERN"."AL_HOURS",0 ) )) + (SUM( DECODE("PS_AL_CHK_HRS_ERN"."ERNCD",'L',"PS_AL_CHK_HRS_ERN"."AL_HOURS",0 ) )) + ( SUM( DECODE("PS_AL_CHK_HRS_ERN"."ERNCD",'E',"PS_AL_CHK_HRS_ERN"."AL_HOURS",0 ) ) ))
FROM
PS_AL_CHK_HRS_ERN
WHERE
"PS_AL_CHK_HRS_ERN"."CHECK_DT" BETWEEN <<FIRST_MO_START, "TO_DATE('"yyyy"-"mm"-"dd"', 'YYYY-MM-DD')">> AND <<FIRST_MO_END, "TO_DATE('"yyyy"-"mm"-"dd"', 'YYYY-MM-DD')">>

 

[CharlesCook]

I posted one (of the many ways to do this) example here:

http://charlescook.com/Examples/TotalHoursByMonth.rpt

Charles

http://CharlesCook.com

Specializing in ReportSmith Training and Consulting

 

[ttrsnoob]

THANKS!