for referencing the value from one cell in another cell, have a look at ReportItems:

https://msdn.microsoft.com/en-us/library/dd255285%28v=sql.105%29.aspx

Your final expression might be something like DATEDIFF(DD, ReportItems!Textbox1.Value, GETDATE()) <= 30.

Are you sure that's the only subscription for this report? Like you, I can't see any reason that schedule would run on Feb 1.

I think Lowell's suggestion of setting the calendar day(s) as 1,15 will work even in a regular subscription; I don't think it has to be a data-driven subscription for that...

Is the parameter being used as a filter in the initial query, or is it only being used in the visibility properties of the report (so it shows only the...

What result do you get with this?

=IIF(SUM(Fields!Hours.Value) > Fields!Max_Hours.Value, "Red",

IIF((SUM(Fields!Hours.Value) < Fields!Max_Hours.Value OR IsNothing(SUM(Fields!Hours.Value))), "Green" ,

"Orange"))

Alternately you could try this (older syntax):

=IIF(SUM(Fields!Hours.Value) > Fields!Max_Hours.Value,...

In Parameter Properties, do you have the "allow null value" box checked?

Have a look at the Data Source the reports are using - that is what dictates what user's permissions are being passed to the database. If the Data Source...

Have you tried a format like this for Switch?

=Switch( (Fields!resource_nextdate.VALUE Is Nothing OR Fields!resource_nextdate.Value < today() ) AND Fields!SR_Status.Value = "Scheduled", “Yellow”,

(Fields!resource_nextdate.VALUE Is Nothing OR Fields!resource_nextdate.Value < today() )...

Maybe try adding /reports to the URL; something like 8001/reportserver/reports. See if that gets you there.

??? A DeLorean...

Can Fields!Amount1.Value be NULL? That might result in the calculation giving NULL (or NULL/100) as a result. When you run the query in SQL, are there any rows...

You could try changing the expression to something like this:

=IIF((Sum(Sum(Switch(Fields!Data_Center.Value="Revenue",Fields!Amount1.Value))-sum(Fields!Amount.Value))/Sum(Switch(Fields!Data_Center.Value="Revenue",Fields!Amount1.Value)))= 0, "0", ((Sum(Sum(Switch(Fields!Data_Center.Value="Revenue",Fields!Amount1.Value))-sum(Fields!Amount.Value))/Sum(Switch(Fields!Data_Center.Value="Revenue",Fields!Amount1.Value)))*100)/100)

Though depending on your data you might be able to get away with a simpler version:

=IIF(Fields!Amount1.Value) =...

Is the report pointing to same data source in SSRS that it points to in Visual Studio? That's the only thing I can think of right off.

In 2008, in the Dataset properties, you should see options down the left for Query, Fields, Options, Filters, etc. Select Query, and near the lower right is a "Refresh...

In Visual Studio 2005, you right-click on "Report Datasets" on the Data tab and select Refresh. In 2008, the refresh option seems to have moved into the Dataset properties...