Reporting options - reviews per project in a given timeframe

[Amrita Aviyente]

Hi

I wanted to know what are the reporting options I have for generating reviews.

We are not using any SCM integration. Reviews get created using attachments.

I am trying to get stats on the reviews done. Something like reviews created per project in a given month. Any idea how I can generate that?

It is running on HSQLDB.

[Renjith Pillai]

You could do it with a simple REST client to dump the reviews from Crucible. Another option is to dump the data into Excel and do all the statistics as per your requirement.

http://code.google.com/p/crucible-excel-dump/w/list

[Amrita Aviyente]

I tried it and ran into issues.

Have you tried this before? Can you share an example?

[Renjith Pillai]

You can check the source at http://code.google.com/p/crucible-excel-dump/source/browse/trunk/CrucibleData/MainForm.cs