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..
Submit an article or tip