Category Archives: Training

Recertified as MCT for 2013

According to Microsoft, the Microsoft Certified Trainers (MCT’s) are the premier technical and instructional experts on Microsoft technologies, and are the only individuals authorized to deliver training with Microsoft Official Courses.

I have been certified as MCT and delivered Microsoft Official Courses since 2009.

Since the requirements are getting more and more stringent for every year and the MCT certification requires both the technical certifications to be current and the student feedback to be above bar I am very happy to announce that this is the 5th year I am certified as a MCT.

The 2013 certification also brings a nifty new look to the logo and certificates.

While I’m still in Sweden I deliver my training through Addskills, the leading training provider in Sweden. Contact me if you are interested in participating in a session or would like to discuss custom training sessions.

I am also available for mentoring and custom training for both BI and SharePoint and for certification preparation work.

HTML5: Free training, exam voucher and more!

With the new approach for SharePoint 2013 to use apps with CSOM, created with HTML5, JavaScript etc, it is time to get going on client side programming.

(Update: The free exam voucher is apparently no longer available due to popular demand…)

Fortunately Microsoft has resources for you:

  1. Free Exam – Get a free voucher to take exam 70-480: Programming in HTML5 w/ JavaScript + CSS3. Find the voucher code. http://aka.ms/HTML5OfferMVA
  2. Free Training – Want to learn HTML5 or brush up before taking the exam? Sign up to access the free online HTML5 course. http://aka.ms/HTML5OfferMVA
  3. Free eBook – Courtesy of Microsoft Press, “Programming Windows 8 Apps with HTML, CSS, and JavaScript”  http://aka.ms/win8apps-ebook 
  4. Free Events – Microsoft Learning Partners are holding #TechShowcase events around the world. Find and attend one near you: http://aka.ms/TechShowcase

Copied From: HTML5: Free training, exam voucher and more! – Veronica’s Blog – Born To Learn

MSDN: More information on Apps for SharePoint

How to: use select all in a Tablix filter

This post describes one way to let users select all values in a filter in a data area such as a Tablix in Microsoft SQL Server Reporting Services.

During a recent Reporting Services 2008 course (6236) I was asked about how to use filtering in a data region, such as a Tablix, and present an option for the user to select all filter values.

A search for doing this with parameters gives you quite a few tutorials, such as Chris Hays’s from 2004. Searching for the same approach for filtering doesn’t yield the same amount of tutorials. So here is a quick guide for a similar approach for select all in filters.

This guide will use SQL server 2008 r2 and BIDS based on Visual Studio 2008.

Initial tasks for demo

Step 1, start BIDS and create your empty Reporting Services project

1-createproject

Above: Screenshot of the new project dialog.

Step 2, Create a new empty report (not through the wizard)

2-createemptyreport

Above: Screenshot of Add New Item dialog.

Step 3, Create a demo dataset (with an empty data source)

3-demodataset

Above: Dataset dialog.

Step 4, Create a Tablix and bind it to our dataset

4-Tablix

Above: Screenshot of report body with a Tablix bound to our dataset and with the detail row showing our data field

Step 5, Preview report

To verify that we are still on track, check the preview of the report and make sure it displays our demo data

5-preview

Above: Screenshot of preview of our not so impressive report

Step 6, Create a Parameter

To be able to filter our dataset through a prompt we need a parameter. We will create a manual one. Please use proper datasets mapped to your data for production reports.

6-ParameterForFiltering

Above: Manual filter items for all and for each of our demo data values.

Step 7, create filter in Tablix

Go to Tablix properties and choose the filter tab.

For our Filter Expression we want to create a filtering expression that can evaluate to true. In a traditional filtering expression we would just choose our field and choose to compare it to our parameter. In this scenario we want to do the logic in this expression so that we can do whatever logic is needed. In this case we choose to compare either to one of the parameter values , or check if the parameter is 0 (our “All” value from the parameter settings)

7-filterexpression

Above: Expression for Filter

For our Value expression we want to evaluate true so that we can compare the two. Note that we need to enter “=true”, not just “true”.

8-filterexpressionpart2

Above: Screenshot of Filter value expression.

Once we have our two expressions our filter properties for the Tablix will show as this:

9-filterdialog

Above: Filters dialog in Tablix properties

Step 8, test filtering

Run report and choose All in parameter:

10-filteredresultall

Above: All data visible with All filter

Verify functionality with a specific parameter:

11-filteredresult1

Above: Only some data is visible when filtering with parameter

More on filtering

The whole point on using data area filtering versus using data set parameters can be expanded on quite a bit. There are loads of resources on that around.

But trying to be complete: One aspect is how much data you want to generate from data source on initial report run, another is if you want to be able to run the same report with different data without generating another trip to the source. By using parameters and filtering on the data set you only retrieve a limited amount of data. By using filters you can run your report once against the data source and then filter on the intermediate result in a cache or on a report snapshot.

Demo Report

Here is the report file used in the demo

 

Free ebook: Introducing Microsoft SQL Server 2012

Ross Mistry and Stacia Misner’s book “Introducing Microsoft SQL Server 2012” is available from Microsoft:

http://blogs.msdn.com/b/microsoft_press/archive/2012/03/15/free-ebook-introducing-microsoft-sql-server-2012.aspx

Stacia Misner has a whole part of the book dedicated to BI.

 

[googleplusauthor]