如何在Crystal Report中设计交叉表报表... [英] how to design Cross Tab Report in Crystal Report...

问题描述

你好！

我想在水晶报表中设计交叉表报表.但是问题是，当我开始创建作品时，我无法获得愿望报告.我想在列中以及每个主题下方输入主题名称，我想输入诸如期中分数，最终分数和分配分数等标记.
我尝试了很多次以显示报告，但是却无法显示.和第二个在同一行中的选项卡中，我只想输入Names，Roll#和Reg#.

我该怎么做....

hello!

I want to design cross tab report in crystal report. but the problem is that when a started to create i can''t get the desire report.i want subject name in column and below each subject i want to enter marks like mid term,final and assignment marks etc.
i tried many times to display the report as I want but it can''t. and 2nd in a same tab in row wise i just want to enter Names, Roll# and Reg#.

How can i do This....

推荐答案

您可以使用此一个

引用链接，
A
自定义交叉表报告 [ ^ ]

子列效果提示
例如

refer link,
A
Customized Crosstab Report[^]

tips for sub columns effect
e.g.

    subjects
----------------
Math | Eng | Sci 

然后查询数据应该像这样

then query data should like this

MastColId SubjId SubjNm Marks StdId StdNm
1         1      Math   90     1    abc
1         2      Eng    91     1    abc
1         3      Sci    92     1    abc
1         1      Math   70     2    xyz
...

如果您没有MastColId，只需添加它

if you not have MastColId simply add it

select 1 as MastColId, subjid,subjnm... 

现在，在交叉表中

now, in crosstab

Columns       = MastColId, SubjId
Rows          = StdId, StdNm
SummaryField  = Mode(Marks)

祝您编码愉快！
:)

Happy Coding!
:)

这篇关于如何在Crystal Report中设计交叉表报表...的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！