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.
One more question: How can I modify Student Transcript A (R-ASR032-E) so that the print-outs are sorted in class number.
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.
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
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.
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
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.
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
這個學藉表(R-STU51-C_1_20080623.rpt)確實非常實用,但我發覺在學生活動及學生獎懲兩個欄位上卻沒有任何紀錄(部分學生有去年部分紀錄),不知是甚麼原因? 我是合併年終獎懲的,而課外活動只有一個時段。
本校想出學藉冊,但以上提供的範本"R-STU051-C-1"發現不能不能在websams2.0正常運作,可否提供一個修正版本呢?<br /> <br /> <br /> EDB-EddieKwan 寫道 :<br /> jr1999 君:可參考此範本﹝以 R-STU051-C-1 為基礎﹞:學籍表 。系統及資訊管理組