How to create reports based on TFS Source Control content?

[woojtii]

Hello,


I have a task to create set of reports based on data from TFS source control.



I must create these reports using reporting services technology.



As an example, I have a report that must count net line of code checked-in last day by specified user.



What technology and approach should I take to realize this task?


Is it possible to get source code data from source control directly to reports using SQL/T-SQL or need use Source control API?



Had someone of you done similar task?




Thanks!

Wojtek