SQL + Jaspersoft
I have the SQL written to gather one record per student containing multiple assessment scores. I am trying to put this data into a Crosstab, but it isn't working. I have three variables indicating the assessment category, testing term, and score. I have a group defined in Jaspersoft and am including the Crosstab in the summary by student ID. See images below...
-
Official comment
Hi Marianna,
Can you provide a mock up or sketch of what you want the CrossTab to look like? Without knowing what the end result needs to look like, I’m not exactly sure how to help.
A CrossTab is typically used to either (A) flatten your data, or (B) aggregate data. It sounds like your data is already flat (i.e. 1 record per student), so are you trying to aggregate data?
If you describe to me what the end result should look like, I’m sure I can steer you in the right direction.
If you prefer, please schedule an online meeting so we can work on this together. That might be a quicker/easier way to solve this problem. If you’d like to schedule a meeting with me, please click this link to see my availability and book an appointment with me. Thanks!
I have available appointments for both tomorrow (Thursday) and Friday.Comment actions -
Thanks Marianna! That is helpful. Unfortunately, you do not, however have your data structured correctly, if you want to use a CrossTab to accomplish this format. A CrossTab will not work for you if you have a flat data structure with one record per student.
A CrossTab would work perfectly if your data looked like the table below. The example is just partial data for one student, and I entered "1" as the score for every assessment, but you get the idea. You would have MANY rows per student, not one.
If you want to create a table with the flat data structure that you currently have, you would use the "Detail" Report Band. I'm happy to walk you through it if you'd like. -
Please book an appointment:
Please click this link to see my availability and book an appointment with me. Thanks!
This is the first mock-up I did in preparation. I would like to separate assessments by subject area... but I am just trying to get them to show up first.Please sign in to leave a comment.
Comments
5 comments