Page 1 of 1

How to create a custom report?

Posted: Mon Mar 29, 2021 10:15 am
by leongtmnn
How do you create your own reports? Is there a collection of existing custom reports somewhere?
Creating a custom report is my task right now but none of the tutorials / steps in TL documentation seem to work as theyre all outdated (often referencing folders that don't exist)
Would it be possible to create a configurable report where the user can create a report with the data he chooses?

Thanks for any help with this.

Re: How to create a custom report?

Posted: Tue Mar 30, 2021 7:21 pm
by fman
The only way to create a custom report is to write it from scratch.
My suggestion is to understand what is the data you want to extract, create the queries (views, store procedures) and use Grafana as visualization tool.
This approach has some minor drawbacks:
- you will need to create your users also in Grafana and will not inherit the test project/test plan permissions
- you will need to use another tool/system (Grafana)

But due to the power of Grafana you will be able to do things that will be difficult using PHP and the testlink code.
Using views, and store procedures you will be able to extract the data and then choose where to display it:
an excel (I hope no :( ), Grafana or any other visualization tool.

I'm using this approach on TESISQUARE (www.tesisquare.com) to govern the certification cycles of TESISQUARE PLATFORM.

Re: How to create a custom report?

Posted: Wed Mar 31, 2021 1:20 pm
by leongtmnn
fman wrote: Tue Mar 30, 2021 7:21 pm The only way to create a custom report is to write it from scratch.
My suggestion is to understand what is the data you want to extract, create the queries (views, store procedures) and use Grafana as visualization tool.
This approach has some minor drawbacks:
- you will need to create your users also in Grafana and will not inherit the test project/test plan permissions
- you will need to use another tool/system (Grafana)

But due to the power of Grafana you will be able to do things that will be difficult using PHP and the testlink code.
Using views, and store procedures you will be able to extract the data and then choose where to display it:
an excel (I hope no :( ), Grafana or any other visualization tool.

I'm using this approach on TESISQUARE (www.tesisquare.com) to govern the certification cycles of TESISQUARE PLATFORM.
Thanks for the reply fman. Unfortunately I think implementing another tool like Grafana would go beyond the scope of my project. I will continue to try to extract all the necessary data through the available excel reports that TestLink provides automatically and assemble the data with VBA in excel, especially because my result should be an automated powerpoint-presentation.

Cheers

Re: How to create a custom report?

Posted: Wed Mar 31, 2021 6:04 pm
by fman
Using Grafana is not complicated and a good investment, while the excel way is ... well not a good thing to do IMHO.