Yes, we are investigating an integration with Jasper Soft, and we will think about developing a simple built-in reporting mean -which could be somewhat powerful thanks to our query language (OQL), but the idea is not to reinvent the wheel anyway!
Meanwhile, you have several options:
Access the database directly with a MySQL client, and use the built-in itop views ; the views cope with the complexity of the object-oriented data model ; the views and their columns are named after the iTop data model, therefore the data model browser is helpful to take all benefits of this feature.
Access the data by the mean of the run_query page, and integrate it into a third-party application. For instance, with Excel you can import data in a dynamic way using the web queries and invoking run_query with the html format. Unfortunately, we didn't succeed in using the equivalent feature in Open Office Calc. You will find more information into the administrator's guide.
Regards,
Romain
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
hi people while this happens (jasper soft integration)
My boss will really like see a report of case progress; AFAIK that implies modify some parts of the BD. But I see as prospect to the reporting this project https://sourceforge.net/projects/php-report/
For my previous employer, I wrote a functional (but highly experimental and often changing) report module which allowed to quickly create reports (it does require some knowledge) which can also be rendered as a PDF.
I've been working on a newer version with better PDF rendering which I might offer for a small cost. I'm open to pilot projects for a discount. It could also come with features such as reports that are sent on a certain schedule (time + day of week).
Mind: the actual extension will be some sort of framework; custom reports will still need to be "programmed" (for now).
Consider it a start of something which can grow and be more user friendly :)
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
iTop is exploring JasperSoft integration and developing a built-in reporting tool. For now, use MySQL clients or run_query for reports. A new module with better PDF and scheduling features is coming, which could benefit lead generation agencies needing detailed insights.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi, are you planning on adding reports and the ability to create custom reports from the GUI in a later version?
Hi,
Yes, we are investigating an integration with Jasper Soft, and we will think about developing a simple built-in reporting mean -which could be somewhat powerful thanks to our query language (OQL), but the idea is not to reinvent the wheel anyway!
Meanwhile, you have several options:
Access the database directly with a MySQL client, and use the built-in itop views ; the views cope with the complexity of the object-oriented data model ; the views and their columns are named after the iTop data model, therefore the data model browser is helpful to take all benefits of this feature.
Access the data by the mean of the run_query page, and integrate it into a third-party application. For instance, with Excel you can import data in a dynamic way using the web queries and invoking run_query with the html format. Unfortunately, we didn't succeed in using the equivalent feature in Open Office Calc. You will find more information into the administrator's guide.
Regards,
Romain
Thanks for the reply, the idea of integrating with Jasper Soft sounds like an interesting one I would love to see this in the future
hi people while this happens (jasper soft integration)
My boss will really like see a report of case progress; AFAIK that implies modify some parts of the BD. But I see as prospect to the reporting this project
https://sourceforge.net/projects/php-report/
From a whole https://sourceforge.net/search/?q=php+reports&sortdir=desc&limit=25&sort=num_downloads_week
./..
Any advice regarding https://sourceforge.net/projects/php-report/ on iTop??
Thanks!
I'd also really like to see a reporting module in iTop. I'm trying (and failing) to create a basic report that lists FunctionalCI against Contact.
Combodo's working to make OQLs more user friendly, perhaps that may help a bit.
If not: I'm also working on a concept of a reporting tool. :)
For my previous employer, I wrote a functional (but highly experimental and often changing) report module which allowed to quickly create reports (it does require some knowledge) which can also be rendered as a PDF.
I've been working on a newer version with better PDF rendering which I might offer for a small cost. I'm open to pilot projects for a discount. It could also come with features such as reports that are sent on a certain schedule (time + day of week).
Mind: the actual extension will be some sort of framework; custom reports will still need to be "programmed" (for now).
Consider it a start of something which can grow and be more user friendly :)
Nice. Its helpful
Last edit: Lawrencebruce 2024-09-12
iTop is exploring JasperSoft integration and developing a built-in reporting tool. For now, use MySQL clients or run_query for reports. A new module with better PDF and scheduling features is coming, which could benefit lead generation agencies needing detailed insights.