SSRS get lat's sunday's date expression!

By -
A recent question about how to get the last Sunday's date expression in SSRS.
so it's simply could be done using the SWITCH function in SSRS, the same concept could be used to get any date of the week's days.

=switch (
Weekday(today) = 1, today,
Weekday(today) = 2, dateadd("d", -1, today),
Weekday(today) = 3, dateadd("d", -2, today),
Weekday(today) = 4, dateadd("d", -3, today),
Weekday(today) = 5, dateadd("d", -4, today),
Weekday(today) = 6, dateadd("d", -5, today),
Weekday(today) = 7, dateadd("d", -6, today)
)
Hope that helps someone...

Comments

  1. AnonymousApril 11, 2012 at 2:27 PM

    Nice. MUCH more simple and straightforward than everything else I have seen so far today.

    ReplyDelete

Post a Comment

Popular posts from this blog

Open SSRS Linked URLS in a new window

By -
Image
Greetings....as I mentioned before sometimes I use my blog posts as a way to remind myself of the stuff that I need frequently and never keep to memory. I needed to add a link in a new SSRS report and the link has to open in a new browser's window. Just Right click on your report field, select "Text Box Properties", select "Action", click on the "FX" sign to write that special expression. ="javascript:void(window.open('" + Fields!URL.Value + "','_blank'))" Assuming that your URL is dynamic and the column name is "URL" in your dataset SSRS Link in  new Browser's Window Hope that helps...
Read more

SSRS Font Weight expressions

By -
Image
Recently I was tasked to edit an old SSRS report, the report has multiple columns and I need to change the font weight to BOLD based on a specific value. It's so simple but annoying that it needs to be done manually to all the columns that you need the expression to check. which was 25 columns in my case! Steps: Right-click on the column and select "text Box Properties" Select "Font" from the left menu Next to BOLD click on the expression menu In the expression screen; write the expression based on your column and the condition. =IIF(Fields!JB.Value > 0, "Bold","Normal") So here I'm setting the Property "FontWeight" of the textbox to be "Bold" when the value is greater than 0, otherwise, you're setting it to "Normal". hope that helps!
Read more