It is still not working especial the DTD part,

Basically my initial query was using the getdate() function and for the DTD I was using datepart(dd,getdate())-1 to get the previous...

It is still not working especial the DTD part,

Basically my initial query was using the getdate() function and for the DTD I was using datepart(dd,getdate())-1 to get the previous...

HI, Thank you very much for the time you spent trying to assist me, but the results I'm getting when using the datediff is excatly the same as what I'm...

Your blog post is too good but is not helping in my problem, can you give me another example with two or more conditions before then

Just to reply...

The problem with my query is that the AND on the case statement seems not to be working as supposed, most of the example that I saw does not include...

I can't identify the error, Please assist

Thanks , I learned I lot

Ok,

Can you assist as how to use the between function in conditional formatting:

Here is my expression:But it takes the "BLACK colour instead of "AMBER"

IIF(Fields!ID3.Value = Fields!Three.Value and Fields!ID4.Value = Fields!Two.Value,"AMBER","BLACK")

Secondly:

How...

Yes, But it is not working properly. It takes the second color.

Second problem: How do I shade the cell instead of the text?

Can I have a conditional format of each "Person Name".For instant each person have got a set target, Then I want to format the "Sales YTD" to quickly see if...

My Question is How to format each row from the details row results that

Please assist me calculate MTD and YTD daily moving average from the example below, Please

Drop table #Calendar

-- simple calendar table

CREATE TABLE #Calendar

(

dt SMALLDATETIME NOT NULL PRIMARY KEY,

IsWeekday AS CONVERT(BIT, CASE...

Captured_DateNumber_Cards_OrderedNumber_Cards_ProducedPrevious_day # of Cards_Ordered

2008/12/03118530 ...

Hi,

This looks helpful. Thanks alot.

cool:

Any suggestion on specific ebook to use