SQL Reporting Services

Why I created a new SQL SRS rdl program

Don’t get me wrong, the latest attempt at saving the Humpty Dumpty holy grail of Reporting Services engines – the rdl file. These kinds of files not only place restraints on what can be created, the also dictate the way in which the file is generated and the way in which the end result — the report — can be used.Just try attaching the file to an e-mail and see how far that gets you.

Okay, so the tool, like so many Microsoft products serve to sell Microsoft.

Who said the  king of monopoly was dead? After all, the tool is free isn’t it?

Well, free doesn’t exactly mean better or best.  And while free sedates the fallacies of the product, id doesn’t mean the work required to produce one single report through it is free.  Nor is its upkeep or are the maintenance and storage costs.

So, if your going to have to use a tool like this, shouldn’t it be a quick and easy to use tool?

Well, it isn’t which is why this article is titled: Why Report Builder 3.0 For SQL 2016 Is Still In The Dark Ages and why I’m offering a solid, better solution.

Consider the following issues:

  1. The tool doesn’t provide the user with a way to easily generate a custom query solely based on table selection.  You have to know what the table name is and then build a query based on it.
  2. The tool doesn’t automatically adjust the width of the fields. You have to manually adjust the sizes of the fields and when you have 60 fields to deal with, the additional time spent on making the adjustments increases the time and the cost of each report.
  3. The tool doesn’t address or resolve the issue of SCOM name and GUID field combinations.
  4. The tool doesn’t automatically remove fields which return nulls. Many WMI calls have fields with null values and are constantly empty.
  5. The lack of documentation and “hand holding” for first timers show a fatal flaw and a lack respect for users whose boss wants a report done and their job is on the line if its not done right.
  6. The tool has a width constraint of 1089. Which is why I believe Microsoft has not opted to auto adjust the fields.

Bottom line: There needs to be a tool built that gets the job done.

There is.


See that little number up at the top left hand corner?  That’s how many seconds it took to produce this:


No need to do anything more to the report.


In alphabetical order, with the guids removed, with automatically adjusted fields.



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.