在列的水晶报表中显示数据 [英] Display data in crystal report in column
问题描述
我想以列模式显示水晶报表。我已经成功地从学生表(带有存储过程)中检索了数据。但想以这种模式显示
I want to display crystal report in column pattern. I have successfully retrieved the data from student table (with a stored procedure). but want to display in this pattern
学生姓名|学生姓名
第一个学生姓名|第二学生姓名
Third学生姓名| FourthStudent Name
First Student Name | Second Student Name
ThirdStudent Name | FourthStudent Name
请告诉我我该怎么做。
推荐答案
这可以通过几个步骤完成,仅当您不需要为每个学生显示其他字段时,此方法才起作用。
This can be done in a few steps, this will only work if you don't need to display other fields for each student.
步骤1-按您要在两列上显示的名称。
Step 1 - Sort the data by the name you want to show on two columns.
步骤2-添加以下公式:
Step 2 - Add the following formula:
IF (NOT(OnLastRecord)) THEN
{StudentName} + ", " + Next({StudentName})
ELSE
""
步骤3-将公式添加到详细信息部分。
Step 3 - Add the formula to the detail section.
步骤4-进入节专家,并将详细节的抑制公式设置为:
Step 4 - Go into the section expert and set the suppression formula for the detail section to:
RecordNumber MOD 2 = 1
这篇关于在列的水晶报表中显示数据的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!