Creating and Customizing TFS Reports

Question

In the process of setting up TFS reports, but the options in figure 10 & 11 from the tutorial below do not show up. It states that on the tab portion of the screen that I should see 'Data', 'Layout', and 'Preview'. All I get is 'Design' and 'Preview'. The metadata screen also never comes up. Please advise.

http://msdn.microsoft.com/en-us/library/ff647430.aspx

Answer 1

Hi BossHogg20,

As I have noticed in the picture posted, you have no dataset for the OLAP datasource. For the 'Data' 'Layout' and 'Preview' screen is designed to show up at the time we create a dataset query as:Building a Simple Query under figure 10.

Thanks,
Lola

---

Please remember to mark the replies as answers if they help.

Answer 2

I thought I followed the directions, what did I miss that would have left out the dataset creation? How do I correct this?

I see the directions (pasted below), but step 1 and the Dataset combo box, is something I don't see either

Building a Simple Query

We’ll be working with the Data tab of the report in this section. To create a new dataset attached to the cube, do the following:

1. In the Dataset combo box, click New Dataset. This opens the Dataset dialog box.
2. In the Name text box, type a name. The example for this article uses the name dsTest.
3. In the Data source combo box, click TfsOlapReportDS (shared). This connects this query to the cube instead of the relational warehouse.
4. Click OK to create this dataset.

At this point, you’ll see a query window that is very different than other query windows you may have seen before, as shown in Figure 11.

Answer 3

Hi,

Without the Dataset combox, you can create the dataset by right-clicking the TFolapReports.ds datasource--Add dataset.

Lola

---

Please remember to mark the replies as answers if they help.

Answer 4

There is nothing that gives the option to add new dataset after I right click.

Add the tabbed boxes are supposed to show up after create reports, according to the instruction in the first link I provided.

My dataset box does not show up like the one in the instructions. I do not get the metadata option and cannot click ok without adding something to the query.

Answer 5

Hi,

Please open the Query Designer in the Dataset Properties pane.

Lola

---

Please remember to mark the replies as answers if they help.

Answer 6

Just from looking at your original post and taking a quick skim through the tutorial you are trying to complete, it looks like you are using SSRS 2008 and attempting a tutorial from the 2005 platform. I've tried this before and there are a lot of small changes that will throw you off :)

Not sure which step you're at but to get the designer shown in Figure 11. you need to have created the shared datasources(in solution explorer), then in the 'Report data' pane create a datasource which uses the new shared source(in your case an SSAS source). Right-click your new datasource in the report data pane and then add dataset, when you select the SSAS datasource as the source, clicking on the query designer will bring up a query designer for cubes as shown in Fig 11.

Hope this helps

Regards,

Ben

Answer 7

Thanks