We would like to create our own custom reports without having to go through the effort of writing code. We have a reporting tool in-house that we can leverage.
by: Existing V1 Request L. | over a year ago | Reporting & Analytics
Completed
Custom Reporting
by: Existing V1 Request L. | over a year ago | Reporting & Analytics
Copyright © 2025, Digital.ai Software, Inc. All Rights Reserved
Comments
I was about to create a new idea, but I think I can just comment this since it could be merged with this one. It would be great if we could moreover have the faculty to create the reporting page, so that we can show to our stakeholders one page with all the reporting needed, with the chance to add comments above each report.
This report page could be exported, and if you export it as excel file, please don't forget to remind to export also the progress % (by now the field is left blank), while using images for the pdf exporting would be great.
One thought here is if the V1 team were to create some views or similar in the delivered database that would facilitate access by a report writing too (Crystal etc) that would go a long way. We have come to learn the schema over the years, and do a number of reports, and also use the API to pull things into Excel, but it would go a long way to have a simplified view of the data. I don't think (my opinion) the V1 team needs to make a report writer tool in v1, just make it a little easier to get at the data that is there.
I definitely agree with the approach of using views in the V1 database that external reporting tools can use. It would be difficult for the V1 developers to be able to anticipate all the variety of reporting that an org would want to do. We have actually written an app that pulls from V1 on a regular basis and imports into a datawarehouse. It has tables/rows for stories, projects, effort, themes, etc. We do our reporting against that. But it is incomplete (not all V1 objects are represented) and takes a fair amount of effort to get it correct and figure out how to keep it current in 5-minute intervals - getting deltas from the V1 API is not easy - we needed to go straight to the V1 DB which is difficult to understand.
I added an IdeaSpace idea for this, but it's not getting much attention, so I figure this is the better place for it.
I do believe that as a user of V1 I should be able to tailor the tool so that it supports my development process. Without customized reports, sometimes I have a feeling that I have to tailor my process to the tool...
For various reasons we chose V1 as a standard tool in our organization but I have used several different agile planning tools in past. I would suggest looking how Mingle does custom reports/charts.
I'd like to be able to create my own reports in some generic way. Examples of reports that I have to build manually (usually by getting info via REST api):
- project the completion date using avg estimates on not yet estimated stories (useful when not entire backlog is estimated)
- amount of carryover per iteration (carryover = unfinished stories moved to next iteration)
- velocity per head (the usefulness is debatable but yet... why not?)
- backlog quality - estimated stories vs not yet estimated
Anyway, v1 is a very good planning tool but I'm still looking forward to seeing some progress on custom reporting feature!
Custom reports is a hard thing: "Hey, make the tool able to generate any kind of report I might ever want.". Having a good report add-on mechanism might go a long way. If the community could develop custom reports, and the tool had an easy way to include them into the main UI, I thing V1 could solve this problem with minimal effort. I realize this is complicated if V1 is hosting the server - they want to ensure the custom reports don't take down/bog down their servers.
We actually built a weekly extract using the REST API, and load key data into Oracle tables where we then use SAP Business Objects for our own custom reporting. While it's not real-time, a set of supported extracts may be one possible mechanism to help with this.
If a web service that describes the entities using WSDL is provided in addition to the REST based services, Crystal Reports can be design using the web service as a data source. I created my own adapter that puts a tiny web service around the REST service so that I could easily print story cards from crystal reports. It works great so I know this concept works.
JoAnn is your WSDL file available somewhere?
I would love to be able to report off my version one system using crystal reports.
Integration with a tool like this: http://www.logixml.com/oem/ would be a plus.
This is available in the Winter 2010 Release. Custom Analytics contains Role Based Dashboards, Analytic Grids and the ability to create and share Custom Reports. More information is available at http://www.versionone.com/Product/Analytics.asp