Peter Trast (4/19/2011)

---

Abbreviations come in 3 basic flavors (with some subsets):

1. Shortened form i.e. co. for company

2. Initialism, first letters...

Good one. Sometimes you get going along a certian thought process and you don't think about other ways....then when you think outside your own boxed in thought process you...

Taxes

Make sure your dataset shows a result for all months, even if the result is zero.

DOH! I clicked too fast. Good question.

If the result with all formatting removed is zero, then formatting it as a...

If you remove all formatting expressions what do you get for X?

mariadziewulska (4/14/2011)

---

Hello,

Am trying to work out a percentage in an SSRS Matrix.

This calculation involves the hours per activity against total amount of hours per WeekCommencing and per Team.

The...

This is a bit of code that I believe originated on Pinal Dave's website. It takes column data and turns it in to a comma delimited list. I...

Now that's racing! IMHO.

crookj (4/13/2011)

---

Pocket full of miracles, anything goes, and Feeling Groovy were their...

Did you see what you started Ray? Good one!

When you say SSRS, do you mean Visual Studio? If so, refresh your report in Preview mode. In order to render a report faster VS will frequently display...

I definitely learned something this morning, thanks.

A common technique in the data warehousing world is to create a dates or calendar table that list all the possible permutations of a date. ie.:

date

calendar year

fiscal year

calendar quarter

fiscal...