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
Posted Monday in Confluence

Organizing your space just got easier - Page Tree Drag & Drop is here

Hi Community! I’m Elaine, Confluence Product Manager. You may have read my earlier post about page tree in space navigation sidebar. I'm excited to share another improvement that helps you organize ...

148 views 3 4
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