Microsoft SSRS Consulting
Let’s face it. SSRS is no longer a “cool” tool. Microsoft wants you on PowerBI and your marketing folks probably bought Tableau and didn’t tell you.
But sometimes, you need detailed reports to run your business, not just fancy charts and graphs. As a NAV customer, you already own SQL Server and therefore SSRS. When your Jet Reports are just too slow, SSRS allows us to leverage the power of SQL to turn 3.5 hours of Excel agony to 20 seconds of reporting joy.
What’s better is that SSRS can report over ALL your SQL Server data, not just what’s in NAV, and we can dump it all to Excel.
The benefits of working with us
With our knowledge of SQL Server, what we build behind the scenes can be reused when you move to another tool.
And, since Microsoft knows that not everything can be expressed in a five-color chart, you can even move your SSRS reports to PowerBI if you choose to go in that direction.
Tips and tricks for using SSRS
In the following posts, you’ll find the tips we use on a day-to-day basis. Be sure to check our blog, too, for the full library. If you still need help, request a consult.
-
4 min readHow to Export to Excel Without Making a Mess
-
3 min readSSRS Consultant Tip: Conditional Formatting
-
3 min readSSRS Consultant Tip: Multiple and Shared Datasets
-
2 min readSSRS Consultant Tip: Stored Procedures vs. Views for SSRS Reports
-
3 min readSSRS Consultant Tip: Keep Your SQL in Your Database
-
2 min readSSRS Consultant Tip: What SSRS Does Well (And What It Doesn’t)
-
3 min readWhat to Criticize (and Not Criticize) as an SSRS Consultant
-
4 min readSSRS Consultant Tip—Round Your Numbers, Don’t Just Format
-
6 min readSSRS Consultant Tip: Defaulting Your Parameters
-
3 min readSSRS Tip: Put Parameters in Your Query, Not Your Filter
-
4 min readUnderstanding Row Level Security (Before SQL Server 2016)
-
5 min readBuilding an SSRS Trial Balance for Dynamics GP
-
3 min readListing Your SSRS Reports With a SSRS Report—Part 2
-
2 min readFinding Stored Procedures Used by SSRS Reports
-
3 min readList All Your SSRS Reports—With a SSRS Report
-
2 min readSeven Keys to Cost Effective Business Intelligence: Intro
-
3 min readSSRS Tabbed Reports
-
3 min readCreating SSRS Parameters—From Simple to Complex
-
3 min readSSRS – Adding Date to Exported Filenames
-
2 min readRepeating Header Rows with SQL Server Reporting Services
-
3 min readJoining the Evil Empire – Recommending Microsoft SSRS
-
2 min readRoom for Some Views Pt. 2 – Summarizing Tables
-
3 min readRoom for Some Views—Understanding the Value of Database Views for Reporting