Hi everyone,

i am currently trying to create a report using 'type' Microsoft sql server. i have a due date to create a working report but i do not have the time to actually sit down and play around with it and see what works and what doesnt, and a demo video would be very very helpfull

Thanks

There is a video here http://teamsystemrocks.com/files/10/team_foundation_server/entry164.aspx showing how to create a custom report. You will have to modify the steps they take a little.

I posted the steps below in your other thread - if you don't want to use the built-in data sources change their names and put them in the same folder as the report (or whereever else is appropriate).

Here are the steps to create a new report that, when deployed, will use the built-in data sources. These data sources are "connected" to the reporting warehouse and cube (one to each).

Nick --

What are the Reporting Services and SQL permissions/roles that I would need assigned to my AD account in order to access the TfsReportDs and TfsOlapReportDS data sources without requiring full administrative privs. Ideally, we would want to go with read only privs.

Thanks,
Tim