Page 1 of 1
See and export Report on Chart
Posted: Tue Mar 02, 2021 2:13 am
by sacom01
hi team,
I have two question with Report :
1. I need a summary report for some specify services on chart, which will show (Last, Avg, Max) and need export it to PDF/JPG
I found whole menu on Report but did it show table report only. Pls guide me where i can find it.
2. Go to Report -> Legacy Reports -> Availability and tick to Output in CSV format, it down load a .php file. I remember CSV will export .xls file. I'm unable to open .php report file. How to export with .xls or PDF/JPG?
Thank you.
Re: See and export Report on Chart
Posted: Tue Mar 02, 2021 7:21 pm
by ssax
1. Their isn't currently a report that shows Last, Avg, Max for a specific subset of services. The closest you can get would be to view them under Home > Performance Graphs and add the services to a dashboard and then schedule the dashboard as a report by clicking the very top right menu with the three horizontal lines in it and clicking the first icon for schedule page.
2. I'm able to replicate this, if I open the avail.php in a text editor I see it has the CSV data. Once the avail.php file has downloaded, please rename it to avail.csv and it should open properly. Then just open in it excel and save as XLS, there isn't currently an XLS export option in XI. I will get this submitted to development.
You could go to Reports > Legacy > Availability and setup the report how you want it (don't check the CSV box) and then run it, then once it's finished you can click the very top right hand menu with three horizontal lines in it and click the first icon to schedule the page as a report which will come out in a PDF.
Re: See and export Report on Chart
Posted: Tue Mar 02, 2021 10:58 pm
by sacom01
hi ssax,
i found schedule for chart report. thank you.
avail.php i have changed to avail.csv but it not show on table.
Re: See and export Report on Chart
Posted: Wed Mar 03, 2021 7:00 pm
by ssax
What do you mean it does not show on table? Please explain what you mean by that.
It's a CSV file. You would need to save it as an XLS to do any advanced XLS stuff like pivot tables if that's what you're referring to.
Re: See and export Report on Chart
Posted: Wed Mar 03, 2021 9:36 pm
by sacom01
hi,
i want export report like below but it only allow export csv
Re: See and export Report on Chart
Posted: Thu Mar 04, 2021 6:26 pm
by ssax
You could go to Reports > Legacy > Availability and setup the report how you want it (don't check the CSV box) and then run it, then once it's finished you can click the very top right hand menu with three horizontal lines in it and click the first icon to schedule the page as a report which will come out in a PDF.
That will get you the PDF of it.
Re: See and export Report on Chart
Posted: Sun Mar 07, 2021 9:51 pm
by sacom01
hi ssax,
i got it bro. thanks for your support
pls close the topic
Re: See and export Report on Chart
Posted: Mon Mar 08, 2021 9:21 am
by scottwilkerson
sacom01 wrote:hi ssax,
i got it bro. thanks for your support
pls close the topic
Locking thread