# Integrate Tryton with report manager like Jasper

**URL:** <https://discuss.tryton.org/t/integrate-tryton-with-report-manager-like-jasper/5642>\
**Category:** Ideas\
**Created:** [October 26, 2022, 10:04pm UTC](https://discuss.tryton.org/t/integrate-tryton-with-report-manager-like-jasper/5642 "2022-10-26T22:04:33Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![aeochoa8](https://discuss-cdn.tryton.org/letter_avatar_proxy/v4/letter/a/858c86/32.png) [@aeochoa8](https://discuss.tryton.org/u/aeochoa8)\
**Post date:** [October 26, 2022, 10:04pm UTC](https://discuss.tryton.org/t/integrate-tryton-with-report-manager-like-jasper/5642/1 "2022-10-26T22:04:33Z")

</div>

Integrate Tryton with a report manager like Jasper that allows you to view the reports and choose which format to export to

---

<div class="post-metadata">

**Author:** ![pokoli](https://discuss-cdn.tryton.org/user_avatar/discuss.tryton.org/pokoli/32/22_2.png) [@pokoli](https://discuss.tryton.org/u/pokoli)\
**Post date:** [October 27, 2022, 6:19am UTC](https://discuss.tryton.org/t/integrate-tryton-with-report-manager-like-jasper/5642/2 "2022-10-27T06:19:16Z")

</div>

There is a third party module for building reports using jasper:

> **[GitHub - NaN-tic/trytond-jasper\_reports](https://github.com/NaN-tic/trytond-jasper_reports)**
>
> Contribute to NaN-tic/trytond-jasper\_reports development by creating an account on GitHub.

---

<div class="post-metadata">

**Author:** ![ced](https://discuss-cdn.tryton.org/user_avatar/discuss.tryton.org/ced/32/1237_2.png) [@ced](https://discuss.tryton.org/u/ced)\
**Post date:** [October 27, 2022, 9:40am UTC](https://discuss.tryton.org/t/integrate-tryton-with-report-manager-like-jasper/5642/3 "2022-10-27T09:40:10Z")

</div>

The main issue with using a third report manage is that you loose the common access right and also the modularity.  
There are only very few documents as reports that need to be printed, most of them are better as table queries (which can be exported as CSV) like we did for sale, purchase and product margin reports.  
Finally the relatorio template based on OpenDocument are kind of WYSIWYG but it could be improved if we provided a way to run the report with mocked records which returns random data for fields but that looks like real data (like party.name will return “John Doe” or product.name “ACME Product” etc).

---

<div class="post-metadata">

**Author:** ![pokoli](https://discuss-cdn.tryton.org/user_avatar/discuss.tryton.org/pokoli/32/22_2.png) [@pokoli](https://discuss.tryton.org/u/pokoli)\
**Post date:** [October 27, 2022, 11:57am UTC](https://discuss.tryton.org/t/integrate-tryton-with-report-manager-like-jasper/5642/4 "2022-10-27T11:57:56Z")

</div>

> [@ced](#):
>
> also the modularity.  
> There are only very few documents as reports that need to be printed,

Well there are companies that tend to produce a lot of documentation, but as far as the data is in a system designing a report in OpenDocument is quite straight forward. Also there are some companies that are already generating the documents using Office format, so migrating this formats into Tryton is quite straigh forward.

To Be Honest, I’ve used both jasper and OpenDocument and I find OpenDocument easier. Of course there are some tricks that you should learn but this is with any other reporting.

> [@ced](#):
>
> Finally the relatorio template based on OpenDocument are kind of WYSIWYG but it could be improved if we provided a way to run the report with mocked records which returns random data for fields but that looks like real data (like party.name will return “John Doe” or product.name “ACME Product” etc).

We’ve created some anonymize script using [Faker](https://pypi.org/project/Faker/), maybe we can use such library to implement what you propose.