Hi Phill.

Actually, the information is not summarising the main table's information so I couldn't go that route but thanks for pointing that out.

I was able to achieve what I...

I think I might have sorted this out. If I add another table in the body of my report and populate it with my summary information, that achieves the same...

OK, I finally got this working. I almost gave up a few times due to frustration and lack of time.

What I ended up doing was uninstalling and reinstalling Reporting Services...

Thanks Phill.

I have discovered that although my settings are such that I should be tracing all components, I'm only getting trace files created for ReportServerService. I had been getting trace...

Thanks Steve and Phil.

To answer Steve, when I go to the 'My Subscriptions' area of my browser, I see my subscription but the 'Last Run' column has no value and the 'Status'...

I tried this for my configuration and it made no difference. I even tried a subscription without a link or attachment and I still don't receive an e-mail.

This is very...

I should have mentioned that the job behind the subscription runs as expected. I can see this from Enterprise Manager. It reports no errors yet the e-mail is not being...

JT,

What kind of problem are you having with subscriptions? I have another e-mail thread going from yesterday in which I describe a subscription problem I'm having.

My subscription is supposed to...

Update ... I figured out the problem and it was my own fault!

It turns out that I was setting up the Role Assignments at the report folder level only when...

Thanks for the response, Andrew. Unfortunately, it didn't seem to make a difference.

I already had Everyone with Read & Execute, List Folder Contents and Read security permissions on the actual...

Thanks for the tips.

That's a good idea, thanks.

I think I didn't word my question that well. I was considering mixing my code with Msgbox commands (to use when I running the package directly...

Thanks for the feedback, Mike.

Yes, as much as I enjoy the little break from the office these conferences offer, I really couldn't justify going to one annually since, as you say, there aren't...

Many thanks. I'll check out that custom task you refer to.

Noel,

I think we are both saying the same thing here. I claimed that the default setting was that cursors would be created as GLOBAL.

This is congruent with your correct statement...