How to create reports based on TFS Source Control
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?