Why Report Builder For SQL 2016

Why Report Builder For SQL 2016

So why do I believe Report Builder 3.0 For SQL 2016 should be of interest to you?

Because it is a killer application armed with a suite of sweet diversities the likes of which makes its predecessors look bad.


Now, I’ve got to admit, the last time I worked with Report Builder, you had to do a lot of heavy lifting,

Not so for this bad puppy. So, I clicked on the Table Wizard just to see what would happen.


Okay, so I clicked next.


Then I clicked new


My Interest began to tickle. It says Microsoft SQL Server in a combo box? Hum, wonder what happens when I click that?


Wait a minute, I can’t pronounce half this stuff, much less know how to use it.

So, I tried OLEDB and then selected Microsoft.Jet.OLEDB.4.0 provider. That option then allowed me to select a mdb file using the DataLinks.


I then tested the connection:


After I clicked on the okay button, a textbox on the main wizard form revealed the connection string.

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=”C:\\Program Files (x86)\\Microsoft Visual Studio\\VB98\\NWIND.MDB”

What did dampen my enthusiasm are the following:

The wizard would not accept a blank password and the query builder didn’t provide me with a list of possible tables.

But okay, I’ll us products.


I clicked next. I didn’t have a clue one what I was supposed to do with the next window.

As it turns out, putting the field values in the value list box gets the job done.


When I clicked next, I was offered formatting options and another next, some color schemes.

Clicking next produced this:


Add the word products to the title. Then discovered the run Button:


And clicked it with my mouse:


I’m not saying that this is god’s gift to reporting. But it comes close. Still has some pitfalls before canonization.

Still, it is addicting as all get out for us men and women who have been dealing with connection strings and queries.

For certain, you want to dabble with various levels of possibilities. Which makes this product armed and dangerous — in a humorous kind of way.



Contact Us

On Key

More Posts

Mastering Azure AD Connect - A Comprehensive Guide by WME
Active Directory

Mastering Azure AD Connect – A Comprehensive Guide

Modern businesses are fast moving toward cloud-based infrastructure. In fact, cloud-based business is not just a trend anymore but a strategic necessity. Microsoft’s Azure Active Directory (Azure AD) has become a frontrunner in this domain. It

Read More »
Security Best Practices in SharePoint
Office 365

Security Best Practices in SharePoint

Microsoft SharePoint is an online collaboration platform that integrates with Microsoft Office. You can use it to store, organize, share, and access information online. SharePoint enables collaboration and content management and ultimately allows your teams to

Read More »
The Ultimate Guide to Microsoft Intune - Article by WME
Active Directory

The Ultimate Guide to Microsoft Intune

The corporate world is evolving fast. And with that, mobile devices are spreading everywhere. As we venture into the year 2024, they have already claimed a substantial 55% share of the total corporate device ecosystem. You

Read More »
Protecting Microsoft 365 from on-Premises Attacks
Cloud Security

How to Protect Microsoft 365 from On-Premises Attacks?

Microsoft 365 is diverse enough to enrich the capabilities of many types of private businesses. It complements users, applications, networks, devices, and whatnot. However, Microsoft 365 cybersecurity is often compromised and there are countless ways that

Read More »
Be assured of everything

Get WME Services

Stay ahead of the competition with our Professional IT offerings.