Maybe with

=IIF(Fields!Category.Value < Fields!Periodic.Value ,"red","black")

?

If actual is less than budgeted I would think that is a good thing. I would highlight it...

If you are seeing the new data source under the data sources folder, but the preview still complains of a reference to the old source, try clicking the save button....

Get me? (11/24/2015)

---

How large is each image file? Even if you scale them in reporting services it just uses html attributes or CSS for scaling but doesn't shrink the...

Just curious, to move on to the next step... the default behavior is for the current job step to complete reporting success. Are these steps you refer to in the...

The log message that you posted are from the job itself and not the SSIS Package. Do you have, if not you should, logging enabled within the SSIS package? If...

No matter how the package is invoked or from where, it will run on the machine it is saved in. What exactly are you aiming for ? The fact that...

Ok thank you Jack, I shall read up on that article

Jack Corbett (11/24/2015)

---

Yes that is how it should work. The first row is inserted successfully because it won't violate the PK and the next row with the...

I'm with Jack on this one. A duplicate to me is where all column values are equal, if you mean duplicate key fields... then the issue is which is the...

You can have your main query in the form of ::

SELECT /* your columns */

FROMyour table

WHEREdateField>= @startDate and dateField < @endDate

Set startDate ,@endDate default to the value of...

Inside of the SSRS development environment you can create a data set that has this information, that is, the calendar months that Jeff Mentioned. You want that table/dataset to...

I've seen this issue when the report itself dumps tons of possible values for the parameter. Can the values be grouped somehow and chosen through a cascading relationship between the...

The purpose of a shared/common data source is that when you need to redirect to a new database, you only need to change the configuration at one place rather than...

Even if it is a valid user at the database, do you have the select permission on the objects that you need or are you calling a stored procedure that...

You need to make sure that the credential configured at the data connection is valid for the database you are getting on your new server. Is this a SQL login...