Hmm. Did the temporary textbox with =reportitems!textbox13.Value < -10 return True when the value is -80?

You may look through the rdl code itself and search for textbox13 and see if...

You could try creating another temporary textbox with a value of =reportitems!textbox13.Value < -10 and see if it is evaluating to True when the value of textbox13 is -80. If...

You need to escape the apostrophe you want in the field with another apostrophe, and since it is a string literal, it needs to be enclosed in apostrophes. The following...

I find that your posted code works as you want, so there may be something else going on. One thing you could try is taking advantage of a default condition...

dragosbucur2000,

You need to specify a length for your VARCHAR declaration. When you declare a variable as VARCHAR without a length specified, it defaults to VARCHAR(1). Thus, you are only seeing...

Optimally, in SQL 2008, we would declare @dt as a date type instead of datetime and there would be no time issue. Then we would remove the CONVERT...

Nigel/Wildh,

In my original post (768063), I convert the result to style 101 (mm/dd/yyyy), so it doesn't matter if @dt has a time or not.

DECLARE @dt datetime

SET...

Try this script to find a term in just about any SQL object.

DECLARE @searchFor VARCHAR(MAX)

SET @searchFor = 'search term'

SELECT OBJECT.object_id,

...

I still prefer the following to get to the first of the month:

SET @dt = DATEADD(d,1-DAY(@dt),@dt)

Nigel, nice! Your arithmetic is very crafty and gets a solution in a...

Here is another approach with the advantage of restoring the @@DATEFIRST value after your calculation:

DECLARE @dt datetime, @date1st int

-- Save @@DATEFIRST so we can restore it later

SET @date1st...