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...

John Mitchell-245523 (10/5/2016)

---

You haven't given any examples of exactly what you're trying to prevent, but from your description, it sounds as if you could do all this (except the e-mail)...

I'm going to admit here, triggers are not my forté. I rarely use them as our main database is third party, and repopulated every night (so we have no need...