How to arrange data horizontally and vertically in the same ireport table?
up vote
-1
down vote
favorite
I need to print a report with table that has values in both type vertically and horizontally.
MySql query to retrieve data is:
SELECT
CONCAT(initial, '.', fullName) AS fullName,
scoreTotal,
scoreAverage,
term_exam.Status,
place,
subjectName,
termExaScore, markSymbol,
gradeName
FROM
mbsm_system.term_exam
LEFT JOIN
term_exam_result ON term_exam.idterm_exam = term_exam_result.idTermExam
LEFT JOIN
student ON term_exam.idStd = student.idstudent
LEFT JOIN
grade ON term_exam.idClass = grade.idgrade
LEFT JOIN
subject ON term_exam_result.subId = subject.subjectCode
WHERE
termExamYear = '2018'
AND idClass = 2
Table image
So I need to print data horizontally following three columns:
"subjectName", "termExamScore", "markSymbol"
So one row of table should like this:
I can enter subject manually one by one but the problem is how to add termExamScore and markSymbol as above given figure?
Please help..
jasper-reports
edited Nov 19 at 22:01
Alex K
18.2k1478150
asked Nov 19 at 19:57
udara chinthaka
72
add a comment |
up vote
-1
down vote
favorite
I need to print a report with table that has values in both type vertically and horizontally.
MySql query to retrieve data is:
SELECT
CONCAT(initial, '.', fullName) AS fullName,
scoreTotal,
scoreAverage,
term_exam.Status,
place,
subjectName,
termExaScore, markSymbol,
gradeName
FROM
mbsm_system.term_exam
LEFT JOIN
term_exam_result ON term_exam.idterm_exam = term_exam_result.idTermExam
LEFT JOIN
student ON term_exam.idStd = student.idstudent
LEFT JOIN
grade ON term_exam.idClass = grade.idgrade
LEFT JOIN
subject ON term_exam_result.subId = subject.subjectCode
WHERE
termExamYear = '2018'
AND idClass = 2
Table image
So I need to print data horizontally following three columns:
"subjectName", "termExamScore", "markSymbol"
So one row of table should like this:
I can enter subject manually one by one but the problem is how to add termExamScore and markSymbol as above given figure?
Please help..
jasper-reports
edited Nov 19 at 22:01
Alex K
18.2k1478150
asked Nov 19 at 19:57
udara chinthaka
72
add a comment |
up vote
-1
down vote
favorite
up vote
-1
down vote
favorite
I need to print a report with table that has values in both type vertically and horizontally.
MySql query to retrieve data is:
SELECT
CONCAT(initial, '.', fullName) AS fullName,
scoreTotal,
scoreAverage,
term_exam.Status,
place,
subjectName,
termExaScore, markSymbol,
gradeName
FROM
mbsm_system.term_exam
LEFT JOIN
term_exam_result ON term_exam.idterm_exam = term_exam_result.idTermExam
LEFT JOIN
student ON term_exam.idStd = student.idstudent
LEFT JOIN
grade ON term_exam.idClass = grade.idgrade
LEFT JOIN
subject ON term_exam_result.subId = subject.subjectCode
WHERE
termExamYear = '2018'
AND idClass = 2
Table image
So I need to print data horizontally following three columns:
"subjectName", "termExamScore", "markSymbol"
So one row of table should like this:
I can enter subject manually one by one but the problem is how to add termExamScore and markSymbol as above given figure?
Please help..
jasper-reports
edited Nov 19 at 22:01
Alex K
18.2k1478150
asked Nov 19 at 19:57
udara chinthaka
72
I need to print a report with table that has values in both type vertically and horizontally.
MySql query to retrieve data is:
SELECT
CONCAT(initial, '.', fullName) AS fullName,
scoreTotal,
scoreAverage,
term_exam.Status,
place,
subjectName,
termExaScore, markSymbol,
gradeName
FROM
mbsm_system.term_exam
LEFT JOIN
term_exam_result ON term_exam.idterm_exam = term_exam_result.idTermExam
LEFT JOIN
student ON term_exam.idStd = student.idstudent
LEFT JOIN
grade ON term_exam.idClass = grade.idgrade
LEFT JOIN
subject ON term_exam_result.subId = subject.subjectCode
WHERE
termExamYear = '2018'
AND idClass = 2
Table image
So I need to print data horizontally following three columns:
"subjectName", "termExamScore", "markSymbol"
So one row of table should like this:
I can enter subject manually one by one but the problem is how to add termExamScore and markSymbol as above given figure?
Please help..
jasper-reports
jasper-reports
edited Nov 19 at 22:01
Alex K
18.2k1478150
asked Nov 19 at 19:57
udara chinthaka
72
edited Nov 19 at 22:01
Alex K
18.2k1478150
asked Nov 19 at 19:57
udara chinthaka
72
edited Nov 19 at 22:01
Alex K
18.2k1478150
edited Nov 19 at 22:01
Alex K
18.2k1478150
edited Nov 19 at 22:01
Alex K
18.2k1478150
18.2k1478150
asked Nov 19 at 19:57
udara chinthaka
72
asked Nov 19 at 19:57
udara chinthaka
72
asked Nov 19 at 19:57
udara chinthaka
72
72
add a comment |
add a comment |
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53381767%2fhow-to-arrange-data-horizontally-and-vertically-in-the-same-ireport-table%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
