Solved

TFS Report using custom field

Posted on 2011-02-17
1
1,459 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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Viewers will learn how the fundamental information of how to create a table.

911 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

16 Experts available now in Live!

Get 1:1 Help Now