報告範本 List out all students' info in Non-attendance Summary Report by Class

本文由 ptam 在 2019-10-17 發表於 "WebSAMS 討論區" 討論區

標籤:
  1. 55708113

    ptam
    Expand Collapse

    文章:
    105
    讚:
    0
    Non-attendance Summary Report by Class (R-ATT003-E) is good as it only displays students with at least one of the non zeros figures in the fields: abs, late and early leaves. However, is it possible to list out all student records, even though the students have all 0 figures in abs, late and early leaves or departed?

    Have tried using Section Expert (Suppress) to modify all 0 in the following syntax:

    ( Sum ({@SABSNT}, {SP_ATT_RPT003.sdatttype}) = 0
    and Sum ({@Slate}, {SP_ATT_RPT003.sdatttype}) = 0
    and Sum ({@SEARLYLEAVE}, {SP_ATT_RPT003.sdatttype})= 0 )
    and ({SP_ATT_RPT003.sdatttype}<>'D')

    Thanks.
     
  2. 57873296

    edb-rn
    Expand Collapse

    文章:
    387
    讚:
    0
    Since Non-attendance Summary Report by Class (R-ATT003-E) is generated by "Stored Procedure" in the Websams Database.

    The Data Result in Stored Procedure has been already filtered out the student records which have all 0 figures in abs, late and early leaves, before passing to Crystal Report.

    Therefore, it is unable to modify the records in the Crystal Report.
     

    附件文件:

  3. 55708113

    ptam
    Expand Collapse

    文章:
    105
    讚:
    0
    Many thanks!!