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

Tough one. I'd bet Team Foundation Server uses SQL as a backend, although it might be difficult enough to figure out that the API could be a better choice. I've used TFS for source control, but don't know the answer; sorry.

You might be able to run a SQL trace and figure out what's involved, though.