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