Thanks, Kevin. Certainly will if I can!

Excellent. Will do.

Thanks again

Paul J

Many thanks, Gethyn: I heard some of Mr O's sessions at SQLBits and it's already on my list.

Excellent to have it recommended as well, though.

Cheers

Paul J

If you have suitable access to SSIS, you might be able to try this:

1) Set up the subscription on the report server fro a date already passed

2) Identify the ID...

I'm not sure of the Teradata syntax either, I'm afraid, but I would construct directly it in the SQL statement this way:

SELECT ... FROM ... WHERE StateName = @state_parameter OR...

Simon,

Have you tried putting the NI value as a calculated field using the same expression?

That way, NI comes through as a reliable value each time and can be subtotaled...

Please forgive if this has already been covered, but directing to port 8500 seemed to fix a similar situation in my organisation:

http://servername[/i%5D:8500/reports produced the Report Server as expected,...