印 T1A1, T2A2, T3A3 和 T1的分紙

本文由 Miss Chung 在 2006-09-23 發表於 "WebSAMS 討論區" 討論區

  1. 55036539

    Miss Chung
    Expand Collapse

    文章:
    120
    讚:
    0

    請問若我想印T1 的A1, A2, A3 和 T1的分紙, 我希望他們能在同一頁顯示, 如下:

    class No. | name  |  T1A1 | T1A2 | T1A3 | T1  |

    02          | XXX    |   50    |    20  |   30  | 100|

    我該如何?

    我試用ASR014印, 同時選取了T1 的A1, A2, A3 和 T1, 但出了四頁紙, 實有點浪費。

     
    #1 Miss Chung, 2006-09-23
  2. 55078679

    Bogey
    Expand Collapse

    文章:
    16
    讚:
    0

    你係想一次過出哂所有科,定係揀特定某一科o黎出?

     
  3. 55036539

    Miss Chung
    Expand Collapse

    文章:
    120
    讚:
    0

    按科目出, 例如:F1A班IS

    Miss Chung

     
    #3 Miss Chung, 2006-09-24
  4. 55036539

    Miss Chung
    Expand Collapse

    文章:
    120
    讚:
    0

    補充:

    例如:F1A班IS

                     IS測  is考   is 平時分     term1成績

    1A01  XXX  40     30      2                 72

    1A02  YYY  30     20      10               60

    請指教!

    Miss Chung

     
    #4 Miss Chung, 2006-09-24
  5. 45331765

    EDB-EddieKwan
    Expand Collapse

    文章:
    0
    讚:
    0

    Miss Chung:

    可試試以下SQL語句。

    select V.CLASSCODE, V.CLASSNO, S.ENNAME,
           JA1.SYSSCORE 'T1A1',
           JA2.SYSSCORE 'T1A2',
           JA3.SYSSCORE 'T1A3',
           JT1.SYSSCORE 'T1'

    from VW_STU_LATESTSTUSCHREC V

    left outer join TB_STU_STUDENT S
      on S.SUID=V.SUID and S.STUID=V.STUID

    left outer join TB_ASR_SUBJASSESSDATA JT1
      on JT1.SUID=V.SUID and JT1.STUID=V.STUID and JT1.SCHYEAR=V.SCHYEAR and
         JT1.SCHLEVEL=V.SCHLVL and JT1.SCHSESSION=V.SCHSESS and
         JT1.CLASSLEVEL=V.CLASSLVL and JT1.TIMESEQ='1100' and
         JT1.SUBJCODE=?

    left outer join TB_ASR_SUBJASSESSDATA JA1
      on JA1.SUID=V.SUID and JA1.STUID=V.STUID and JA1.SCHYEAR=V.SCHYEAR and
         JA1.SCHLEVEL=V.SCHLVL and JA1.SCHSESSION=V.SCHSESS and
         JA1.CLASSLEVEL=V.CLASSLVL and JA1.TIMESEQ='1101' and
         JA1.SUBJCODE=JT1.SUBJCODE and JA1.MOI=JT1.MOI

    left outer join TB_ASR_SUBJASSESSDATA JA2
      on JA2.SUID=V.SUID and JA2.STUID=V.STUID and JA2.SCHYEAR=V.SCHYEAR and
         JA2.SCHLEVEL=V.SCHLVL and JA2.SCHSESSION=V.SCHSESS and
         JA2.CLASSLEVEL=V.CLASSLVL and JA2.TIMESEQ='1102' and
         JA2.SUBJCODE=JT1.SUBJCODE and JA2.MOI=JT1.MOI

    left outer join TB_ASR_SUBJASSESSDATA JA3
      on JA3.SUID=V.SUID and JA3.STUID=V.STUID and JA3.SCHYEAR=V.SCHYEAR and
         JA3.SCHLEVEL=V.SCHLVL and JA3.SCHSESSION=V.SCHSESS and
         JA3.CLASSLEVEL=V.CLASSLVL and JA3.TIMESEQ='1103' and
         JA3.SUBJCODE=JT1.SUBJCODE and JA3.MOI=JT1.MOI

    where V.SCHYEAR=?

    order by V.SCHLVL, V.SCHSESS, V.CLASSLVL, V.CLASSCODE, V.CLASSNO

    系統及資訊管理組

     

     
    #5 EDB-EddieKwan, 2006-09-25
  6. 55036539

    Miss Chung
    Expand Collapse

    文章:
    120
    讚:
    0

    有沒有報表可用?

    或者是更改某報表就可以達到同樣效果?

    因為用Query 之後要由人手分老師, 分班, Check, 有點煩瑣

    請指教!

    Miss Chung

     
    #6 Miss Chung, 2006-09-26
  7. 45331765

    EDB-EddieKwan
    Expand Collapse

    文章:
    0
    讚:
    0
    <FONT color=#006600>Miss Chung,<BR><BR>可試試以下範本: </FONT><A href="http://www.hkedcity.net/citizen_files/aa/ti/emb-eddiekwan/myresources/200609/422690/R-ASR014-Cr.rpt"><FONT color=#0000ff>Revised R-ASR014-C</FONT></A>&nbsp;。<BR><BR><FONT color=#006600>系統及資訊管理組</FONT>
     
    #7 EDB-EddieKwan, 2006-09-27
  8. 教師甲

    教師甲
    Expand Collapse

    [parsehtml]<P><FONT color=#006600>我要SQL語句</FONT></P> <P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; T1A1, T1A2, T1A3, T1, T2A1, T2A2, T2A3, T2, 年終</P> <P>Thanks!!!</P>[/parsehtml]
     
    #8 教師甲, 2006-09-27
  9. 45331765

    EDB-EddieKwan
    Expand Collapse

    文章:
    0
    讚:
    0

    教師甲:

    可試試以下SQL語句。

    select V.CLASSCODE, V.CLASSNO, S.ENNAME,
           J1A1.SYSSCORE 'T1A1',
           J1A2.SYSSCORE 'T1A2',
           J1A3.SYSSCORE 'T1A3',
           JT1.SYSSCORE 'T1',
           J2A1.SYSSCORE 'T2A1',
           J2A2.SYSSCORE 'T2A2',
           J2A3.SYSSCORE 'T2A3',
           JT2.SYSSCORE 'T2',
           JA.SYSSCORE 'Annual'

    from VW_STU_LATESTSTUSCHREC V

    left outer join TB_STU_STUDENT S
      on S.SUID=V.SUID and S.STUID=V.STUID

    left outer join TB_ASR_SUBJASSESSDATA J1A1
      on J1A1.SUID=V.SUID and J1A1.STUID=V.STUID and J1A1.SCHYEAR=V.SCHYEAR and
         J1A1.SCHLEVEL=V.SCHLVL and J1A1.SCHSESSION=V.SCHSESS and
         J1A1.CLASSLEVEL=V.CLASSLVL and J1A1.TIMESEQ='1101' and
         J1A1.SUBJCODE=?

    left outer join TB_ASR_SUBJASSESSDATA J1A2
      on J1A2.SUID=V.SUID and J1A2.STUID=V.STUID and J1A2.SCHYEAR=V.SCHYEAR and
         J1A2.SCHLEVEL=V.SCHLVL and J1A2.SCHSESSION=V.SCHSESS and
         J1A2.CLASSLEVEL=V.CLASSLVL and J1A2.TIMESEQ='1102' and
         J1A2.SUBJCODE=J1A1.SUBJCODE and J1A2.MOI=J1A1.MOI

    left outer join TB_ASR_SUBJASSESSDATA J1A3
      on J1A3.SUID=V.SUID and J1A3.STUID=V.STUID and J1A3.SCHYEAR=V.SCHYEAR and
         J1A3.SCHLEVEL=V.SCHLVL and J1A3.SCHSESSION=V.SCHSESS and
         J1A3.CLASSLEVEL=V.CLASSLVL and J1A3.TIMESEQ='1103' and
         J1A3.SUBJCODE=J1A1.SUBJCODE and J1A3.MOI=J1A1.MOI

    left outer join TB_ASR_SUBJASSESSDATA JT1
      on JT1.SUID=V.SUID and JT1.STUID=V.STUID and JT1.SCHYEAR=V.SCHYEAR and
         JT1.SCHLEVEL=V.SCHLVL and JT1.SCHSESSION=V.SCHSESS and
         JT1.CLASSLEVEL=V.CLASSLVL and JT1.TIMESEQ='1100' and
         JT1.SUBJCODE=J1A1.SUBJCODE and JT1.MOI=J1A1.MOI

    left outer join TB_ASR_SUBJASSESSDATA J2A1
      on J2A1.SUID=V.SUID and J2A1.STUID=V.STUID and J2A1.SCHYEAR=V.SCHYEAR and
         J2A1.SCHLEVEL=V.SCHLVL and J2A1.SCHSESSION=V.SCHSESS and
         J2A1.CLASSLEVEL=V.CLASSLVL and J2A1.TIMESEQ='1201' and
         J2A1.SUBJCODE=J1A1.SUBJCODE and J2A1.MOI=J1A1.MOI

    left outer join TB_ASR_SUBJASSESSDATA J2A2
      on J2A2.SUID=V.SUID and J2A2.STUID=V.STUID and J2A2.SCHYEAR=V.SCHYEAR and
         J2A2.SCHLEVEL=V.SCHLVL and J2A2.SCHSESSION=V.SCHSESS and
         J2A2.CLASSLEVEL=V.CLASSLVL and J2A2.TIMESEQ='1202' and
         J2A2.SUBJCODE=J1A1.SUBJCODE and J2A2.MOI=J1A1.MOI

    left outer join TB_ASR_SUBJASSESSDATA J2A3
      on J2A3.SUID=V.SUID and J2A3.STUID=V.STUID and J2A3.SCHYEAR=V.SCHYEAR and
         J2A3.SCHLEVEL=V.SCHLVL and J2A3.SCHSESSION=V.SCHSESS and
         J2A3.CLASSLEVEL=V.CLASSLVL and J2A3.TIMESEQ='1203' and
         J2A3.SUBJCODE=J1A1.SUBJCODE and J2A3.MOI=J1A1.MOI

    left outer join TB_ASR_SUBJASSESSDATA JT2
      on JT2.SUID=V.SUID and JT2.STUID=V.STUID and JT2.SCHYEAR=V.SCHYEAR and
         JT2.SCHLEVEL=V.SCHLVL and JT2.SCHSESSION=V.SCHSESS and
         JT2.CLASSLEVEL=V.CLASSLVL and JT2.TIMESEQ='1200' and
         JT2.SUBJCODE=J1A1.SUBJCODE and JT2.MOI=J1A1.MOI

    left outer join TB_ASR_SUBJASSESSDATA JA
      on JA.SUID=V.SUID and JA.STUID=V.STUID and JA.SCHYEAR=V.SCHYEAR and
         JA.SCHLEVEL=V.SCHLVL and JA.SCHSESSION=V.SCHSESS and
         JA.CLASSLEVEL=V.CLASSLVL and JA.TIMESEQ='1000' and
         JA.SUBJCODE=J1A1.SUBJCODE and JA.MOI=J1A1.MOI

    where V.SCHYEAR=?

    order by V.SCHLVL, V.SCHSESS, V.CLASSLVL, V.CLASSCODE, V.CLASSNO

    系統及資訊管理組

     
    #9 EDB-EddieKwan, 2006-09-28
  10. 55036539

    Miss Chung
    Expand Collapse

    文章:
    120
    讚:
    0

    較獨立的科目, 如數學, 利用那rpt可以了, 謝謝

    只是, 如是將中文分卷也這樣做, 那rpt 就不能, 請指教!

    miss chung

     
    #10 Miss Chung, 2007-01-09
  11. 55036539

    Miss Chung
    Expand Collapse

    文章:
    120
    讚:
    0

    另外,

    2. 使用那rpt後, 是否意味要放棄本來有的summary? 包括mean, std, passing %等?有沒有法子?

    3. 補充上一回覆:

    我校中文科有三個分卷,我剛試了用你們的RPT, 發現只有中文科的總分之T1A1, T1A2, 及T1A3, 而見不到那些分卷,我該如何?

    謝謝

    Miss Chung

     

     
    #11 Miss Chung, 2007-01-09
  12. 45331765

    EDB-EddieKwan
    Expand Collapse

    文章:
    0
    讚:
    0

    Miss Chung: 

    此範本已將分卷包括在內: R-ASR014-C 修改版 。

    至於平均分、標準差或合格率等資料,一般都需要另外用stored procedure來計算,很難單以修改範本方式去處理。

    系統及資訊管理組

     
    #12 EDB-EddieKwan, 2007-01-11
  13. 45331765

    EDB-EddieKwan
    Expand Collapse

    文章:
    0
    讚:
    0
    #13 EDB-EddieKwan, 2007-01-12
  14. 55036539

    Miss Chung
    Expand Collapse

    文章:
    120
    讚:
    0

    我用Revised R-ASR014-C 卻發現以下答題

    1. 一些只有T1A2, T1A3的科目, 即T1A1不考核的科目, 此版本只出到白紙, 怎辦?

    謝謝!

    Miss Chung

     
    #14 Miss Chung, 2007-01-18
  15. 45331765

    EDB-EddieKwan
    Expand Collapse

    文章:
    0
    讚:
    0
    <FONT color=#006600>Miss Chung:<BR><BR>請試用最新修訂的那個範本吧。<BR><BR>系統及資訊管理組</FONT>
     
    #15 EDB-EddieKwan, 2007-01-18
  16. 55036539

    Miss Chung
    Expand Collapse

    文章:
    120
    讚:
    0

    已用最新修定, 發現以下問題, 請指教......

    1. Subject Group 一出就整級, 而不是Sorted List!

    2. 可否在column 加相應總分, 如T1A1的滿分是120

    3. 一些只有T1A2, T1A3的科目, 即T1A1不考核的科目, 出到了

    謝謝

    Miss Chung

     
    #16 Miss Chung, 2007-01-23
  17. 45331765

    EDB-EddieKwan
    Expand Collapse

    文章:
    0
    讚:
    0
    <FONT color=#006600>Miss Chung:<BR><BR>已新加「滿分」欄位,可試用這個範本。<BR></FONT><BR><A href="http://www.hkedcity.net/citizen_files/aa/ti/emb-eddiekwan/myresources/200609/422690/1025365020.rpt">R-ASR014-C 修改版(包括及格人數、滿分)</A> <BR><BR><FONT color=#006600>不過,不明白閣下所提及的第一個問題:「<FONT color=#000066>Subject Group 一出就整級, 而不是Sorted List!</FONT>」,可否詳加解釋?</FONT><BR><BR><FONT color=#006600>系統及資訊管理組</FONT>
     
    #17 EDB-EddieKwan, 2007-01-26
  18. 45331765

    EDB-EddieKwan
    Expand Collapse

    文章:
    0
    讚:
    0
    #18 EDB-EddieKwan, 2007-01-26
  19. 55036539

    Miss Chung
    Expand Collapse

    文章:
    120
    讚:
    0

    使用了以上的修改版

    1. 科目組別 已能按修讀同學列印, 一頁ok了, 謝!

    2. 按跨班科目 未能列出

    3. 可否只在column 頂 加相應總分, 如T1A1的滿分是120 及 T1A1的中文解說

    4. 本來有的STAT 如 Average, STD, 等, 有出路嗎?

    5. 若我要印 T2A1, T2A2, T2A3, T2 的分紙, 我該怎修改呢?

    Miss Chung

     
    #19 Miss Chung, 2007-06-13
  20. 55036539

    Miss Chung
    Expand Collapse

    文章:
    120
    讚:
    0

    請問各位, 我真不懂如何改Command.t1等柬西為t2, 指教指教!

    若我要印 T2A1, T2A2, T2A3, T2 的分紙, 我該怎修改呢?

    Miss Chung

     
    #20 Miss Chung, 2007-06-21