Hi all,
I have a report where I want to show a blank value if the date content of the field does not equal yesterday.
The data is in varchar format.
eg.
IIF(Fields!Mydates.value <> "Yesterday", "", Fields!Mydates.value)
The part "Yesterday" is where I am struggling to find the right code to basically do getdate()-1, which doesn't seem to work here.
Any help much appreciated.
Humate
Hello,
Im trying to embedd a picture into my detail table rows to have a dynamic bar graph happening with data from a column called winbacks.
1.So Ive created the embedded 'bar' image
2. Ive inserted the image into the row and under the image properties i have put under the padding
=144 * (1.0 - Fields!Winbacks.Value / Max(Fields!Winbacks.Value, "dataset1")) & "pt"
This part is working....and the image is stretching accordingly to scale.
I would now like to put in a condition to use a different image OR write some text in the row field if the Winback.Value is the highest in the table for that row...ie write ''top gun'' on top off the bar image
Im not sure if you can write text and have the image appearing but this would be ideal...
so Iam instead trying to create an image with the text and when the winback value is the highest use that image ELSE use the normal image.
Can someone please help with how to do this
thanks