Skip to Content
0

transpose columns to rows, combine data and draw boxes

Mar 27, 2017 at 06:23 PM

41

avatar image

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Abhilash Kumar
Mar 28, 2017 at 07:45 AM
1

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded

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)
0