This reply is some three months too late.

Using a Union Query to merge the data from the two tables will return all projects whether they have actuals and no forecast...

Thanks for the useful information.

I would have written it as below as I am just getting familiar with the "With" syntax"

SELECT

Employees.EmpID ...

Many thanks Michelle, I have now fixed the problem.

Here is the solution to move the reporting services web site from port 80 to 8080.

1. Go to IIS management and...

I have got a server with a number of partitions running variants of Server 2003 Operating systems including standard, small business server, 64 bit etcetera. I have loaded a variety...