Crystal Reports将交叉表的列标题与另一个字符串连接在一起 [英] Crystal Reports concatenating a column header of cross tab with another string

问题描述

您好.我刚刚以交叉表结构创建了一个报告.我正在使用Visual Studio 2010的附加水晶报表版本13.该报表效果很好，我只是想添加最终的自定义设置和格式，以使其对观众更具代表性.该报告基本上显示了该学校所有学科的不同年级，一年级，二年级等的学生人数.成绩在列标题中显示，科目名称在行标题中显示，汇总字段中的学生人数.现在，我尝试将"Grade"字符串连接到列标题，以便它们读取Grade1 Grade2，依此类推..现在，它们仅显示1、2、3，因为这是将等级存储在SQL Server数据库中的方式.我知道可以选择更改数据库中的成绩，但是我不想这样做，因为我只想从Crystal报表中进行.我尝试通过添加公式为"Grade"和{Result.FinalGrade}来更改列名称的显示字符串，但报表中的所有列标题都显示"Grade 3".任何想法，请回答..

Hi..I have just created a report in cross tab structure. I am using crystal report version 13 add on for visual studio 2010. The report has come out fine and I am just trying to add the final customizations and formatting so that it is more presentable to the viewers. The report basically is showing the count of students in the different grades, grade 1, grade 2 and so on for all the subjects in the school. The grades are in the column headers and subjects names as row headers with the count of students in the summarized fields. Now I am trying to concatenate a "Grade" string to the column headers so that they read Grade1 Grade2 and so on..right now they are only showing 1, 2, 3 as that is how the grades are stored in the SQL server database. I know that an option would be to change the grades in the database, but I don''t want to do that as I only want to do it only from crystal reports. I have tried changing the display string of the column name by adding a formula as "Grade" & {Result.FinalGrade} but it is showing "Grade 3" for all the column headers in the report. Any ideas, please respond..

推荐答案

创建一个包含字符串"Grade"的公式.并在交叉表数据定义中使用该公式(您必须在其中指定列更改条件，而不是直接在报表中).

HTH

Create a formula that includes the string "Grade" and use that formula in the cross-tab data definition (where you have to specify the column change criteria, not directly in the report).

HTH

这篇关于Crystal Reports将交叉表的列标题与另一个字符串连接在一起的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！