יום שני, נובמבר 3, 2008
This post is the seventh and last post that builds the Excel Guide. See the first post here
On this post I will show how using the Excel you can create reports with a click of a button, it is important to mention that you need to have the rights on the reporting services server in order to create reports.
In the Rosario you don't need to be an expert in order to create a very impressive reports, just follow these simple steps:
Step 1: Create a query in order to have more accurate reports, the query must be flat...
יום שלישי, אוקטובר 14, 2008
This post is the sixth post out of seven that builds the Excel Guide. See the first post here
On this post I will talk about the Parent Child relations between work items and how it works with Excel.
In the Rosario there are new type of links, but the most influencing link type that was added to the Rosario is the Parent/Child link.
Parent/Child link links many child nodes to each parent node, a parent can have many children but each child have only one parent so what we get is an hierarchy of a tree type.
יום ראשון, אוקטובר 5, 2008
This post is the fifth post out of seven that builds the Excel Guide. See the first post here
On this post I will talk about the Get Work Items function and how to Change List Configurations that are available in the Excel.
Excel is showing the user only the work items he has chosen to see, what if he likes to add more to that list? This is exactly that reason Excel has the “Get Work Items” functionality.
To get Work Items do the following steps:
Step 1: Click on “Get Work Items” button
Step 2: In the window...
יום שני, ספטמבר 22, 2008
This post is the forth post out of seven that builds the Excel Guide. See the first post here
On this post I will talk about the Publish and Refresh functions that are available in the Excel.
These functions are the back bone of using the Excel with the Team System.The Publish function is used for sending all the changes you made in the Excel to the TFS (Team Foundation Server), which is the server side of the Team System, including new work items you have added.The Refresh function is used for getting all changes from the TFS.
In order to use...
יום חמישי, ספטמבר 18, 2008
This post is the third post out of seven that builds the Excel Guide. See the first post here
On this post I will talk about the Choose Columns function that is available in the Excel.This function lets us choose what fields out of the work item's fields we like to see in the Excel, all the rest of the fields will be hidden from us.
One important thing before we start, when we create new work items from the Excel we still bound to the required fields even if we choose not to show them in the Excel, make sure...
יום ראשון, ספטמבר 7, 2008
This post is the second post out of seven that builds the Excel Guide. See the first post here
On this post I will talk about the export to Excel options that are available in the Team System.
There are two options in the Team System to export work items to excel:
Export from a query.
Export from a query result.
In order to export from a query do the following:
Step 1: Create a query in the Team System project. (Creating a query is out of the scope of this guide)
Step 2: Right click the Query you have just created and...
יום חמישי, אוגוסט 14, 2008
One of the most powerful tools in the Team System is the Excel, when I say Excel I mean the good old Excel tool that we have in our Office tools.
Team System is integrated with Excel which gives the user the ability to use all the grate features of the Excel and still work directly with the TFS (Team Foundation Server), for example lets say I need to change the state field of 100 work items from Proposed to Active, with the Team Explorer I will need to go one by one and change its state but with the...
יום ראשון, מרץ 11, 2007
The Reporting Services enables us to create custom reports for our BI needs.One aspect of creating such a report is sometimes using a built-in sub-report, nested in a Table or Matrix object inside our main report.
This sub-report (which is actually another RDL file) creates a problem when trying to export all the report (main and sub) to Excel and display all its data properly:When we try to view the sub-report data in Excel we see a message: "Subreports within table/matrix are ignored".This problem occurs due to a technological limitation, not solved yet by Microsoft, disabling Excel from rendering correctly...