See the link in my previous post, it tells you how you should share sample data.

Sending stuff over Skype isn't great for a number of reasons.

Your Connection Manager must be set up to treat the first row as a header. Go to your Connection Manager properties for the Excel sheet, and change FirstRowHasColumnName to FALSE.

I'm actually struggling to work out what you're after here, and I'm not really sure I understand your post. I'm really confused by your mention of having an unnamed column.

The...

I do the...

You can't send out 5 copies of the same report with a single subscription no. In fact, from experience, if you start off the same subscription while it's already running...

Ok, then make a second dataset that returns your Country list, and add NULL to the Returned list. Then use that list as your parameter values

SELECT DISTINCT

...

Have you enabled the Country parameter to allow NULL values?

To display reports on a front end page for external users you want the Microsoft.ReportViewer.WebForms Assembly in your web project.

This is something I did with our Web Team maybe 2...

Does this meet your needs? You'll need to change the values of the @StartDate and @EndDate Variables to suit your needs though.

DECLARE @StartDate DATE = '01-Jan-2016',

...

Sean Lange (10/5/2016)

---

Be careful if you use this code as a starting point. It has scalar values being populated from the inserted table. This is very problematic because the inserted...

SELECT DISTINCT

DC.Country

FROM DW.dbo.Dim_Country DC

WHERE DC.Active = 1

AND DC.Country = ISNULL(@Country,DC.Country);

You're attempting to get the list of countries you can choose for your parameter from your dataset, which requires a Country to be selected.

Ok, the URL you're trying to deploy to is the Report Manager URL, rather than the Web Service URL.

You need to enter the URL displayed on your Web Service URL...

The address you need is in your first screen shot. You've blurred it out, so I can't tell you what to enter. This needs to go in your TargetServerURl, which...

Visual studio is telling you exactly what the problem is here, it can't find the server. I'm pretty sure if you navigated to http://localhost/Reports_SQLEXPRESS/%5B/url%5D you would get a "Server not...