Login or Sign Up to become a member!
LessThanDot Site Logo

LessThanDot

A Technical Community for IT Professionals

Less Than Dot is a community of passionate IT professionals and enthusiasts dedicated to sharing technical knowledge, experience, and assistance. Inside you will find reference materials, interesting technical discussions, and expert tips and commentary. Once you register for an account you will have immediate access to the forums and all past articles and commentaries.

Browsing "Excel Reporting"

0

ITPROceed – Slide Deck and demo materials

ITPROceed 2014 is now a thing of the past, but is has been an awesome – and free! – event. A very big thank you and “well done” to the organizers. It has been a great gathering of the #sqlfamily, with superb sessions about Azure, restoring databases with PowerShell, Hekaton (yes yes In-Memory OLTP), Administration […]

Read More...
0

Changing the 1000 separator in Power View

Recently I was designing a simple Power View report on top of a multi-dimensional SSAS cube. Out of the box, one of the tables looked like this: For readability purposes, a 1000 separator is added to the numeric value. However, the comma was used, as is common in the United States. In Belgium (and other […]

Read More...
0

Dude, where’s my Power Map?

If you haven’t noticed lately, Power Map has gone into General Availability as of 25 of February 2014. It comes along with service pack 1 of Office 2013, which you can download here. There are two ways of getting this update: Downloading and installing service pack 1, aka the old-school method. Simply having the Click-To-Run […]

Read More...
4

Rants about Connect

The site connect.microsoft.com is a wonderful concept: you can provide feedback about the Microsoft products, report bugs and give suggestions directly to the teams responsible for those products. People can vote on items to indicate them as more import…

Read More...
0

Nice Collection Of Free SQL Server, Visual Studio, Azure ebooks

Eric Ligman has posted a nice collection of ebooks available in pdf, epub and mobi formats. The books cover Office, Office 365, SharePoint, SQL Server, System Center, Visual Studio, Web Development, Windows, Windows Azure, and Windows Server

Here is…

Read More...
18

Building a SharePoint 2013 BI Demo Environment Part 10 – Creating a BI site

In the final part of this series, we will create a BI subsite in our site collection. You can use this site as the starting point for your SharePoint BI demos. Browse to the PowerPivot site we created earlier in part 7 and go to Site Contents. Click on…

Read More...
2

Building a SharePoint 2013 BI Demo Environment Part 9 – Installing Reporting Services

Finally we are getting to the really sweet stuff: Power View. But first we have to install Reporting Services in SharePoint integrated mode. The steps we are going to follow are described in the following MSDN document: Install Reporting Services ShareP…

Read More...
3

Building a SharePoint 2013 BI Demo Environment Part 8 – Verifying PowerPivot Integration

After configuring SharePoint in the part 7, we will now verify if the configuration was successful and if everything works correctly. The verification process is described in the following MSDN article: Verify a PowerPivot for SharePoint Installation. F…

Read More...
0

Building a SharePoint 2013 BI Demo Environment Part 7 – Configuring SharePoint

In this blog post we go over one of the most important parts of the series: running the PowerPivot Configuration Wizard in order to configure our SharePoint installation. If you followed the previous walkthroughs, you can find the wizard in the start me…

Read More...
3

Building a SharePoint 2013 BI Demo Environment Part 6 – Installing PowerPivot for SharePoint

In this part of the series we will install the Analysis Service instance that will host the PowerPivot workbooks used in SharePoint, also known as “the PowerPivot instance”.
The first step is to create a service account for this instance. I named it SP…

Read More...
Next Page »