Multiple Header in Crystal Report

[Former Member]

Hi,

I need to transpose row data to column data and with multiple column for single common column like shown in below figure.

I want Theory and Practical to be sub-column of Subject Column. How should I do this. I am unaware for this process. Could someone please give me step by step process to achieve this.

Thanks.

[abhilash_kumar · Accepted solution]

Hi Bhuban,

1. Insert a Crosstab.

2. Use the Subject field as the Column.

3. Use the Student field as the Row.

4. Add Theory field as the first summary field and Practical as the second summary field.

5. Right-click one of the summary cells > Select Summarize field Labels > Summarize horizontally.

6. Right-click one of the summary cells > Select Summarize field Labels > Show Summarized Field labels

-Abhilash