Solved

TFS Report using custom field

Posted on 2011-02-17
1
1,458 Views
Last Modified: 2016-02-14
TFS comes with few standard sample reports. For these reports  they have Cubes (SSAS) as back end and SSRS as front end. Cubes datasource is datamart. And there is a SSIS package which imports data from SQL server to Datamart.

Now we have created a custom field in TFS which is saved in SQL server. but this fields is not in datamart or in cubes. I  need to create a report using this custom field.

Please advice.
0
Comment
Question by:didba
1 Comment
 
LVL 27

Accepted Solution

by:
planocz earned 500 total points
ID: 34922774
create a stored procedure and then bring in the dataset to the SSRS report.
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Suggested Solutions

Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Viewers will learn how the fundamental information of how to create a table.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now