0 Replies Latest reply: Sep 20, 2013 4:31 PM by user3176716 RSS

    Total for specific Year

    user3176716

      I am trying to create a simple report in RTF that shows the total number of training hours for the current year at the top of the report, but also shows the details of all training.

       

      I can get it to show all of the details, but am having trouble summarizing Year data, as the data is Date specific LM_COMPL_DT. Right now the report is grouped on /Name.

       

      I have tried a number of things, but am just spinning my wheels at this point. Any help would be GREATLY appreciated!

       

      Thank you,

       

      Michael

       

      Here is the XML:

       

      <TRANSCRIPT>

          <LM_PERSON_ID>27614</LM_PERSON_ID>

          <NAME>Han,William</NAME>

          <LM_CS_LONG_NM>Day One Orientation</LM_CS_LONG_NM>

          <LM_COMPL_DT>23-FEB-09</LM_COMPL_DT>

          <LM_SCORE></LM_SCORE>

          <LM_ORG_DESCR>HRIS</LM_ORG_DESCR>

          <LM_CI_ID>2213</LM_CI_ID>

          <XLATLONGNAME>Completed</XLATLONGNAME>

          <LM_PASS_STTS_LABEL>Pass</LM_PASS_STTS_LABEL>

          <LM_GRADE_LABEL>Pass</LM_GRADE_LABEL>

          <LM_ORGANIZATION_ID>3900</LM_ORGANIZATION_ID>

          <LM_GRADE_VAL_ID>10</LM_GRADE_VAL_ID>

          <LM_PASS_SCH_ID>1</LM_PASS_SCH_ID>

          <LM_PASS_VAL_ID>10</LM_PASS_VAL_ID>

          <FIELDNAME>LM_STTS</FIELDNAME>

          <LM_DURN_HRS>123</LM_DURN_HRS>

        </TRANSCRIPT>