Can you give a little more information please?

Why do you need 2 tables from one dataset?

What on the first table do you need to repeat on every page?

Pictures and sample...

Of the destination server?

I would check a couple of things.

First look at the Reporting Services database Execution log (view or table) to see if you can determine where the hang up is.

Second, if...

Well from your description it certainly sounds PC related. But I would at least check the Reporting Services database execution log (view or table) to make sure it shows...

Ziggy Stardust

Thanks, I needed that. 🙂

in one!!

Hey, that was on AMC just last night. Although they cut so much...

I was suggesting that you put that in your dataset query, not in the report itself.

My experience is that pulling data with a "comb filter" style expression is...

bullseye

Interesting question & explanation. Thanks.

SWITCH is not available in T-SQL.

What is the error?

You say you already checked this. But I would go back and check permissions again. Does the account that the SQL Server Agent uses have permissions to the...

I would add another column to your dataset

CASE WHEN PremiumMonth >= DATEADD(mm,-3,GetDate()) THEN PAmount ELSE 0 END AS P3Amount

Then simply use the P3Amount column for your average

Look at your path to the CSV file. It may be correct when you run from your computer, but incorrect on the server.