OK - answered my own question. This is direct from Microsoft.

If you have 2 boxes - 1 hosts Reporting Services (e.g. report manager / web service / windows service) and the...

Our database contains 95% of current data that can be edited / updated after its been inserted, so we dont really fit the data warehouse model.

The other 5% would...

Thanks for you reply.

The Report Server (my web server) must have a SQL Server Enterprise edition License. The only thing I cannot get absolute confirmation on is whether the database has...

An example using Northwind:

declare @LastName nvarchar(20)

set @LastName = 'All'

select *

from Employees

where LastName = isnull(nullif(@LastName,'All'),LastName)

We have exactly the same issue.

You could use dynamic sql as suggested above, I dont like it though.

We solved it by using a...

in the Jump to URL box try:

="http://www.website.com/default.asp?ID=" & Fields!Quote_Header_ID.Value

note the equals at the beginning and the position of quotes.

hth.

Could you not just query the ReportServer database? Im sure this information you want is there somewhere.

They are stored as XML in the ReportServer database that gets added as pert of the RS install.