Jump to content


  • Posts

  • Joined

  • Last visited

Jason30's Achievements


Apprentice (3/14)

  • Week One Done
  • One Month Later
  • One Year In
  • First Post Rare
  • Collaborator Rare

Recent Badges



  1. Hi all, I need to use 2 groups, both uses the same query but are grouped differently and shows other fields. The output, as Jaspersoft Studio works: The 2nd result of group 1 is between the results of group 2. But does someone have an idea how to keep the group results with eachother? Is it even possible to achieve something like this? Group 1: result 1 Group 1: result 2 Group 2: result 1 Group 2: result 2 Any help or tips are appreciated, thanks in advance.
  2. Hi all, I have made this report in Jaspersoft Studio which needs to be printed 3 times, but with another title. The other information on the report is the same. I have no idea how to achieve this, but I came up with an unnested SQL array first: case when a.unnest = '1' then 'Title 1' when a.unnest = '2' then 'Title 2' when a.unnest = '3' then 'Title 3' end as title_copyFROM table_name join (SELECT unnest(array['1', '2', '3'])) a on true WHERE table_name.service_id = '123456679' [/code] Now I need to make something like a while loop based on 'title_copy' but how can this be achieved within Jaspersoft Studio? If someone have any tips or any other suggestion to achieve 3 (same) pages in Jaspersoft Studio, I would love to hear it. Thanks in advance!
  3. Hi all, The result in a group doesn't show all the records. It seems that it doesn't print the records with the same location ID. The option 'print repeated values' is ON for each field in the group. Group 1 Expression: location_id Query: ORDER BY location_id, name Query result: 5, Mark, street 10, USA5, Mark, street 10, France 7, Steven, street 80, England8, Jason, street 55, ItalyGroup result 5, Mark, street 10, France7, Steven, street 80, England8, Jason, street 55, ItalyThe following result is left out in the group: 5, Mark, street 10, USAObviously it has something to do with the same location_id and name, but I can't figure out why. Does anyone have an idea? Thanks in advance for any help/tip.
  4. Hi, Thanks for your reaction. Unfortunately that option doesn't solve it. I had it also set to true on all the fields in the subreport but with no luck. The subreport is in the Column header. There are 2 items listed which is correct. There is also this big gap between the first and second item which is not desired. Screenshot: http://imgur.com/a/jVx1q If you have more idea's i'd love to hear them. I appreciate the help.
  5. Hi all, The subreport shows a line after each item. In the subreport I only have 1 group configured. There is no line added/configured so it should not show a line. Does anyone have an idea where this line is coming from? Thanks in advance.
  6. Thanks, but let me explain it better. I try to achieve the following: --------------------------- Text: Introduction to tables Group: Table 1 Table 2 Text: Introduction to chairs Group: CHair 1 Chair 2 ----- Note: both groups have the same expression because the information is stored in the same table: $F[info_id] At this moment I get the following result: Text: Introduction to tables Table 1 ---- Text: Introduction to chairs ---- Chair 1 Table 2 ---- Text: Introduction to chairs ----- Chair 2 I don't want the group nested in the first group. Hopefully above is clearly, thanks for the help.
  7. Hi all, I wonder how I can achieve the following structure: TextGroup 1TextGroup 2TextGroup 1 and group 2 shows the multiple items. I just want to add some table or text between group 1 and 2, but I can't figure it out. The solution could be a group 2 header but it repeats itself because group 2 contains multiple items. I need some static text between the groups. Hopefully above is clearly. Thanks for any help or tips.
  8. It doesn't recognise the alias 'CODE'. However, the alias CODE does exists and can be used in the report. But not in the query. Is there a fix for this? Or an other way to achieve it? Thanks for any help.
  9. Unfortunately it doesn't generate the query which holds the 'Code'. Because of the error the field 'ME' isn't available in the report. sum( case when ( Code ='ME') then Weight/1000*5 else 0 end) ME Any idea's? Thanks.
  10. Hi all, I receive the following error: column "Code" does not exists. [/code] (SELECT value FROM table WHERE id = $P{order_id}) as Code, sum( case when ( Code ='ME') then Weight/1000*5 else 0 end) ME, It seems that the query doesn't recognize the subquery. Has anyone an idea what the cause is of this error? Thanks in advance for any help / insights.
  11. Thanks for your reaction Joseng. Sorry for the indistinctness. The value is a calculated field. So in the example there are 6 values (3 in row 1 + 3 in row 2) On the end I want to sum all 6 calculated values. I am new to Jaspersoft, but coding wise I try to achieve something like this: In the group (hidden?): $variable1 = 4$variable2 = 3$variable3 = 3$variable4 = 1$variable5 = 2$variable6 = 1Page footer contains: $total = $variable1+$variable2+$variable3+$variable4+$variable5+$variable6; Hopefully this makes it more clearly. Thanks again.
  12. Hi all, I wonder how to count different values. Example output of the table in the group band: Row 1: Cat 1: 4Cat 2: 3Cat 3: 3Row 2: Cat 1: 1Cat 2: 2Cat 3: 1Then I want to put the total in the last page footer: 14 Note: There could alse be 3 rows, or 4. Thanks in advance for any help / insights.
  13. Thanks for your reaction Hozawa. It's pretty unlogic. I have 3 groups, when I have added the third group then I get this structure in Jaspersoft Studio. Group 1 Group header 1Group 2 Group header 2Group 3 Group header 3Group1 Group Footer 1Group2 Group Footer 2Group3 Group Footer 3When I preview the document then it sorts it exactly like above, this is weird. I want: Group 1 headerGroup 1 footerGroup 2 headerGroup 2 footerGroup 3 headerGroup 3 footerDo you know how I can reach this? Thanks again, much appreciate it.
  14. Hi all, Probably easy to do but I can't figure it out. I have 2 different groups and I just want to show some text between those groups. When I put the text in the group header of the 2nd group then it's attached to the group. Thanks in advance for any help!
  • Create New...