[RESOLVED] SSRS in VS2008 - Embedded Data Source

[InvisibleDuncan]

I've been using this blog post to set up the SQL Server Performance Dashboard reports. However, I can't follow it completely; there's a section that tells me "We need to modify the existing data source to be an embedded data source as using expressions in connection strings is not supported with shared data sources." However, I can't find a way to do this; I only seem able to use shared data sources. They have two screen shots of the data source dialog box, but the second one seems to have grown a couple of options that I don't have.

I'm probably missing something blindingly obvious, so does anyone fancy pointing it out to me?

I'm using SQL Server Business Intelligence Development Studio as found in the tools for SQL Server 2008, which opens up in Visual Studio 2008.

Thanks...

[FunkyDexter]

Confusingly, there are two different things that are referred to as DataSources in SSRS. I'm not sure if they have formal names but I call them Report Data Sources and Shared Data Sources. You're probably looking at the wrong one.

You should have a pane called "Report Data", probably on the left hand side when you open a report. That has a "New" button at the top where you can add a new report data source. Click that and the dialogue box that pops up should contain options to use either an embedded datasource or a shared datasource.

You're probably looking at the dialogue box that's used for adding shared datasources to the project. That's the one you access by selecting add new item or add new data source in the solution explorer.

Hope that helps.

[InvisibleDuncan]

Thank you, my funky friend. That was exactly the answer I needed.