SQL製作學籍表一問

本文由 jr1999 在 2007-09-18 發表於 "WebSAMS 討論區" 討論區

  1. 10109629

    Canyon
    Expand Collapse

    文章:
    81
    讚:
    0

    In fact, I have tried to modify Student Transcript A (R-ASR032-E) myself by putting the subreport Sub-StudentAssessment.rpt in your report provided.  However, it cannot show anything at all. 

     
  2. 10109629

    Canyon
    Expand Collapse

    文章:
    81
    讚:
    0
  3. 55169024

    EDB-Jeff Tong
    Expand Collapse

    文章:
    0
    讚:
    0
    Canyon:

    請試用這個轉用了另一個成績 subreport 的修訂

     
    #23 EDB-Jeff Tong, 2008-06-23
  4. 55169024

    EDB-Jeff Tong
    Expand Collapse

    文章:
    0
    讚:
    0
    Canyon,

    For your enquiry about modifying Student Transcript A (R-ASR032-E) so that the print-outs are sorted in class number, you may open "Group Expert" in Crystal Reports after opening the template. Add VW_STU_LATESTSTUDENT.CLASSNO as another group and move it upward to make it a higher priority than VW_STU_LATESTSTUDENT.STUID.

    After clicking "OK" button, suppress both new Group Header #1 and Group Footer #1.

     
    #24 EDB-Jeff Tong, 2008-06-23
  5. 10109629

    Canyon
    Expand Collapse

    文章:
    81
    讚:
    0

    Thank you very much.  I've done it.  I think I can build my student record based on ASR032-E.  But I still have to insert two subreports

    1) Sub-StudentAssessment.rpt in your report provided,
    2) a sub-report showing his public exam result

    But I don't know how to do.

    Canyon

     
  6. 55169024

    EDB-Jeff Tong
    Expand Collapse

    文章:
    0
    讚:
    0
    For the first question, select the subreport you want, right-click and select "Save Subreport As...". After saving the subreport, open your own template and click "Insert -> Subreport" from the menu. For the "Subreport" tab, browse and select the subreport file that has been just stored. For the "Link" tab, choose SUID and STUID from VW_STU_STUPROFILE. Please refer to <a href="http://www.hkedcity.net/citizen_files/aa/tu/emb-cltong/public_html/eddie_transcript/pic1.png">pic 1</a> and <a href="http://www.hkedcity.net/citizen_files/aa/tu/emb-cltong/public_html/eddie_transcript/pic2.png">pic 2</a>. Finally, click "OK" button and put the subreport on the your template.
     
    #26 EDB-Jeff Tong, 2008-06-23
  7. 10109629

    Canyon
    Expand Collapse

    文章:
    81
    讚:
    0

    I am sorry to tell you that in Student Transcript A (R-ASR032-E) I cannot find the table vm_stu_stuprofile in linking.  And I tried to use the field SUID and STUID in another table to link.  The printout display a empty table in that sub-report.

     

    Canyon

     
  8. 55169024

    EDB-Jeff Tong
    Expand Collapse

    文章:
    0
    讚:
    0
    Canyon,

    I missed that you were talking about R-ASR032.

    Please refer to pic 3 and pic 4. Original parameters must be selected in "Subreport parameter field to use" and it should be done.

     
    #28 EDB-Jeff Tong, 2008-06-24
  9. 10109629

    Canyon
    Expand Collapse

    文章:
    81
    讚:
    0

    Thank you, i have done it.

     
  10. 10109629

    Canyon
    Expand Collapse

    文章:
    81
    讚:
    0

    First of all, thank you for your help and I nearly finish my student record report based on R-ASR032.  Please help me so that I can put the user-defined fields of students (i.e., 學生資料 > 學生概況 > 其他 > 用戶設定欄位的資料) in it.

    Canyon 

     
  11. 55458651

    釗Sir
    Expand Collapse

    文章:
    11
    讚:
    0

    這個學藉表(R-STU51-C_1_20080623.rpt)確實非常實用,但我發覺在學生活動及學生獎懲兩個欄位上卻沒有任何紀錄(部分學生有去年部分紀錄),不知是甚麼原因?

    我是合併年終獎懲的,而課外活動只有一個時段。

     
  12. 55099035

    alice333
    Expand Collapse

    文章:
    2
    讚:
    0
    本校想出學藉冊,但以上提供的範本"R-STU051-C-1"發現不能不能在websams2.0正常運作,可否提供一個修正版本呢?<br />
    <br />
    <br />
    EDB-EddieKwan 寫道 :<br />
    jr1999 君:可參考此範本﹝以 R-STU051-C-1 為基礎﹞:學籍表&nbsp;。系統及資訊管理組
     
    #32 alice333, 2010-03-05
  13. Expand Collapse

    回覆 14# EDB-Jeff Tong

    我將這個template加到學生資料->個人資料->學生資料檔案(依班),未能使用. 請幫忙
     
  14. 56440610

    edb-brian
    Expand Collapse

    文章:
    382
    讚:
    0
    #34 edb-brian, 2011-05-04
  15. 55270414

    tr-lawderek
    Expand Collapse

    文章:
    14
    讚:
    0
    這很好用,但可否加入每一學年的上下學期(即T1, T2)的中文、英文、數學三科的成績以及將整體評語改為課外活動(無需職位及表現)
     
    #35 tr-lawderek, 2012-02-02
  16. 55387784

    Tamsir2012
    Expand Collapse

    文章:
    35
    讚:
    0
    請問 能否加入 一學期 三段考.(T1A1 T1A2 T1A3 ) 於這學藉冊裏? 謝謝
     
    #36 Tamsir2012, 2012-03-07
  17. 55387784

    Tamsir2012
    Expand Collapse

    文章:
    35
    讚:
    0
    修正, 請問 能否加入 一學期 三段考.(T1A1 T1A2 T1A3 )各段考的平均分, 及中, 英, 數 三科的成績 於這學藉冊裏? 謝謝
     
    #37 Tamsir2012, 2012-03-07