VB.Net 2008中的Crystal Reports问题 [英] Crystal Reports in VB.Net 2008 Issue
问题描述
您好，
我在水晶报告中显示数据时遇到问题。我在申请表中成功展示了其他报告。但是，我有一个问题，就是根据自己的喜好在报告中显示数据。我已经尝试了所有方法来使我的报告正常工作，但无济于事，所以我最好在这里发布确切的数据以获得您的帮助。我的报告'的数据来自MS SQL View，如下图所示，第一行是字段名称）：
名称课程出勤TPR TAB TSK
Pete L10 S 2 1 5
Luke L10 P 2 1 5
Mat L10 P 2 1 5
Pete L11 A 1 3 0
Luke L11 S 1 3 0
垫L11 P 1 3 0
请注意以上数据表显示，对于特定课程，每个成员的出勤率是不同的。但是，TPR，TAB和TSK在同一课程中都是相同的，它不会，也不会改变。对于同一课程，这些字段在每个成员名称中都具有相同的值。
现在在水晶报告中，我想要一个如下所示的报告：
名称L10 L11
Pete SA
Luke PS
垫PP
TPR 2 1
TAB 1 3
TSK 5 0
我尝试过十字架-tab报告并设法将报告显示如下所示，但显示如上所示的TPR，TAB和TSK值确实令人困惑。
名称L10 L11
Pete SA
Luke PS
Mat PP
大师，请协助，因为我真的需要这个为我的教会计划工作。
提前谢谢。
Hello,
I have an issue with displaying the data in my crystal report. I successfully showed other reports in my application. However, I have an issue with displaying the data in the report to my liking. I have tried all means to get my report working but to no avail so it''s better I post the exact issue with the exact data here for your assistance. My report''s data is from a MS SQL View as shown below note, first row is the field names):
Name Lesson Attendance TPR TAB TSK
Pete L10 S 2 1 5
Luke L10 P 2 1 5
Mat L10 P 2 1 5
Pete L11 A 1 3 0
Luke L11 S 1 3 0
Mat L11 P 1 3 0
Please note that the above data table shows that, for a Particular lesson the attendance for each member is different. However, the TPR, TAB and TSK are all same for the same lesson, it will not and it doesn''t change. For the same lesson these fields will have the same value all through each member name.
Now within crystal reports, I want to have a report as shown below:
Name L10 L11
Pete S A
Luke P S
Mat P P
TPR 2 1
TAB 1 3
TSK 5 0
I have tried with the Cross-tab reporting and managed to get the report to show as shown below but to show the TPR, TAB and TSK values as shown above is really confusing.
Name L10 L11
Pete S A
Luke P S
Mat P P
Gurus, Please assist as I really need this to work for my church program.
Thanks in advance.
推荐答案
在水晶报告中使用分组。
use Grouping in crystal report.
这篇关于VB.Net 2008中的Crystal Reports问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
