# Posts tagged Microsoft

## Counting rows using conditional dates in Reporting Service

0

I’ve been using Reporting Services a lot. As with many things I learn on a “needs” basis.

Something I’ve done quite a bit of is have to run counts on the data returned by datasets. Something that stumped me early on when I started was how to run a count against data that was returned based on dates.

It was actually nice and simple:
=SUM(IIF(Fields!DateField.Value = Today(),1,0))

In this example what we’re basically doing is checking if the date is equal to “today”, if it is it’s given a value of 1, if not then 0. And of course, it’s summed up. So this would give us the SUM() of dates equal to today.

A variation of this conditional counting (and something I’ve had to do) is to run a comparison like this against a date and a “non date” value.

So in this example our Fields!DateField.Value is actually stored as an integer. So we need to convert the integer to a date to have it count properly.

=SUM(IIF(new DateTime(Fields!WOODDT.Value / 10000, (Fields!WOODDT.Value / 100) mod 100, Fields!WOODDT.Value mod 100) = Today(),1,0))

So in the above example, we are creating a datetime type with our DateTime() function and then comparing it to the Today() value. If the newly created date value (which is again based off of the data returned from the dataset) is equal to today’s date it is given the value of 1, if not then 0. And this is summed up.

## Microsoft CEO Steve Ballmer thinks you need to be a computer scientist to use an Android phone

0

Found this interview with Steve Ballmer, Microsoft’s CEO, and thought it was interesting.

It’s neat to hear him talk about Microsoft’s products and take questions reflecting some of the technology giant’s future. But I just couldn’t help but be amused by some of the question/answers.

For instance, when it came to questions about Windows phones… and then being asked to compare to Apple’s iPhone and Android phones. Ballmer says you need to be a computer scientist to use the Android phone.

Well, come on Steve. It’s really not that bad. Have you ever actually used one? I understand you can’t get excited about Android phones… I mean, you’re trying to sell and push the Windows phones right?? Oh yeah, right.

Anyways. It’s amusing.

The part about the Android phone is at about the 21 minute mark.

Enjoy!

## Microsoft takes direct swing at Google and Gmail with “Gmail Man” video

0

Saw this new ad this morning, where essentially Microsoft desires to help make the case for their Office 365 products by poking fun at their big competition.

Something that strikes me with this kind of advertising though, it resembles those political ads that I really dislike. You know, where one candidate really says nothing about he or she’s platform but instead tries to leave an impression in your mind that the opponent is either wicked, cruel, evil, idiotic….etc.

I’m wondering what, if any, will be Google’s response.

If you haven’t seen it. Here it is….

“Gmail Man”

## Google, Microsoft and Yahoo! team up on schema.org

0

Major search engines, Google, Microsoft and Yahoo! have teamed up to help create some standards so webmasters can help better define the information contained on their website’s pages.

Lack of standards, it could be said, has been a problem for some time.

But this new site, supported by the major search engines, gives clear cut information on how to define data/text by adding simple HTML attributes to DIV and SPAN tags.

Definitely worth a look if you’re creating HTML5 sites.

You can find the website here: schema.org

Check out one of the examples…. A Person Schema

Go to Top