SQL + Jaspersoft



  • Official comment
    Franck Reyherme

    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.

  • Avatar
    Marianna Ripple

    Something similar to this...

    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.

  • Avatar
    Franck Reyherme (Edited )


    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.
  • Avatar
    Marianna Ripple

    Yes, please... I really need to finish this report asap.

Please sign in to leave a comment.