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
Community showcase
Published Mar 12, 2019 in Confluence

Confluence Admin Certification now $150 for Community Members

More and more people are building their careers with Atlassian, and we want you to be at the front of this wave! Important Dates Start the Certification Prep Course by 2 April 2019 Take your e...

1,154 views 2 13
Read article

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