Skip to Content
avatar image
Former Member

transpose columns to rows, combine data and draw boxes

this is how my report looks like at present:

marksheetreport.png

and this is how i want it to be:

marksheetreportword.png

As is evident, rows are transposed into columns. And Subject code is written only once.

Also marks are totalled.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Mar 28, 2017 at 07:45 AM

    Hi Hangkum,

    1. Insert a Crosstab.

    2. Use the Subject field as the 'Row' of the Crosstab.

    3. Use the Second and the Third column from your screenshot as the two Columns in your Crosstab.

    4. Use the Marks Obtained field as the Summarize Field.

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      thanks for the reply.

      My problem is not yet solved.

      This is the output I am getting . k i don't need the subject name . That's why i left it out and I am using only the subject code (eg: cse-408, cse-504) .

      report.png

      Now these are the problems:

      I want to generate one crosstab for each student. Right now, the cross tab is for the two students combined. Therefore the marks shown are actually the summation of the marks of two students. I have two students in my datatable right now(see red circle , top left corner). There must be two crosstabs , one for each student.

      And how can the subject_code must be center aligned( see blue arrow)? . I could not find any property for center alignment.

      Please refer my first post for the format that i need. thanks

      report.png (30.7 kB)