Jasper report for confluence 5

Hello,

Is there a jasper report plugin for confuence 5 ?

Thanl you.

Christophe

3 answers

1 accepted

Jasper Reports for Confluence has not been updated for Confluence 4/5 due to lack of demand. Some significant work was done to update it, but that was halted months ago. JSPR-8 has no votes for instance and you are the first to ask about it over the past year that I am aware of.

Thank you Bob for the very quick answer. I would also like to thank you for the great plugin you have developed which make confluence greater.

My issue for Jasper is that I want to make a report with a group by clause, where only a few fields are different between a couple of lines.

field1field2field3field4

aaabbbcccddd

aaabbbeeeddd

aaabbbfffddd

aaaggghhhiii

for example the result of my sql. I want to have a report showing something like

field1field2field3field4

aaabbbcccddd

eee

fff

aaaggghhhiii

So kind of removing the value of the not first occurence in the group. I use Jasper to produce the report using the group count function and then replacing the field with "" if the value is not one.

Any idea how this could be solved with SQL on Oracle ?

Thank you.

Regards,

Chirstophe

Not sure, but, often you can use a case statement to do something similar. Another option would be a temporary table. Usually, things like this can be done in SQL, it is just more complex to get it working.

We do not have a published plugin for this - but also recently integrated JasperSoft with Confluence and JIRA - and so would be happy to share info around this. Write us if you'd like to discuss your use case, and what you are trying to accomplish.

I finally used the

row_number() over(partition by f_ref order by f_ref)

to get the numbering of the changing rows, and use that in a case statement. Works perfect. But Jasper is still nice to produce nice pdf...

I have voted for it

Thank you

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Posted Jul 10, 2018 in Confluence

We want to see the templates you've created in Confluence!

Hi Community, Jessica here from the Confluence Product Marketing team!  July’s community challenge is all about sharing pictures  — and as an extension of our first post on what ...

913 views 23 12
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you