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.
for example the result of my sql. I want to have a report showing something like
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 ?
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
Hi my Community friends! For those who don't know me, I'm a product marketer on the Confluence Cloud team - nice to meet you! For those of you who do, you know that I've been all up in your Co...
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!
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