I have never had much luck using AND/OR conditional logic inside an IIF. I prefer to nest the IIF statements. Here is how I would write it instead:

=IIF(Fields!Overtime_Cost.Value...

Jump

Report Builder is a separate (Free) download from MS.

Once you know the target folder and target URL, go to the REPORT and right click and choose Deploy and only that report will be deployed.

You can try to deploy it. Make sure you know where the report will deploy to: In solution explorer right click on the project and select properties. Make...

I am a little confused is Local Advertisement text or a field value in your query?

It looks like you are using it as just text. If that is true...

If the version where you want to give it standard values is going to be distributed automatically, then simply set up a data driven subscription.

If you want the report to...

Write your query so that the detail returned is the SUM for Employee. Then in your groups simply drop your value field in the appropriate cell on the report...

A common problem with RS using stored procedures and parameters is the impact of Parameter Sniffing. So much so, that when I write a SP that I am going...

Wish I had a wind turbine.

Kit G (3/21/2011)

You know that stuff is dangerous, don't you?

DHMO in solid form can cause irreparable tissue damage and in...

If it is not showing properly in preview in BIDS it won't be better when you deploy it (with almost no exceptions).

Can you post a screen shot of the Text...

I just added a few more notes above the script that you may want to note.

I just ran a couple more quick tests. For the CC change the parameter...

Is the change visible in the Preview in BIDS (Visual Studio)?

Have you deployed the report after you successfully changed the column name?

I don't think this will find cc or bcc, but I am not sure. For data driven subscriptions, you will need to query the table where the that particular...