Hi there is a DTSlog table which we use to see an audit trail. I can't access our servers to see where it is but this is certainly straight...

That is the address for the site so what address is the site working at if not that one? You can connect to Reporting Services from SSMS instead and...

You can deploy from VS as mentioned, but if you just want to get the reports up there and worry about that later.... You can do the following:

Browse to...

I may be missing the point but isn't this overkill! We have logshipping with email notification when the secondary server gets no update within a set time over a...

Thats OK.

You can buy tools to sit over the front? We use Proclaity over the cubes but deliver SQL reporting via SSRS albeit you can buy tools for end...

You're welcome. Not that I am aware of, sorry.

Things can always be better but to be honest having a job which even resembles secure is a great place to be at present. It is the motivating factors...

I don't understand why the ID is important. Do you want a total based on a subset of the data returned.

Using multiple values requires xyz in (1, 2, 3) etc. If you pass 1, 2, 3 as a variable it is a string but you can't then say where...

We have no plans to move to 2008. It isn't a problem with the server its pretty big and under utilised. It's more the client print control (ActiveX)...

are they trusted domains?

There are MS articles on this which I cant find. On 64 bit servers you should have 1 per CPU, yes. This will give you a better performance...

I may have misunderstood but why not put the total number of pages at the footer of the sub report. This will show at the end of each section...

I agree. The problem is that IE will start to timeout on you when it gets bigger and bigger. I found its far more efficient to run it...

look up rsscripter and download it. Its free and works a treat, don't let some poor sole backup manually. With this you can also run the reports into...