Tags » Reporting Services

SSRS Custom Code - Phone Number Formatting

The problem: a production report pulls a series of phone numbers which need to be formatted as (###) ###-####

Writing a formatting string in an SSRS expression can be tedious. 134 more words

Sql Server

Getting Started With SQL Server Reporting Services (SSRS) - Part 3


Hi friends! This is the third article i am going to write for this series of Getting Started With SQL Server Reporting Services (SSRS). In my first article of this series we saw how to start with SQL Server Reporting Services, requirements for SQL Server Reporting Services, Installation and we have created one simple report. 764 more words


How to build a custom report for Lync/Skype for Business

Recently I’ve dealt a lot with building SQL queries for Lync/Skype for Business for different purposes, such as queries for: Calls Duration, Network type usages, Amount of poor calls per site etc.. 997 more words


Reporting Services error in log : ThrowIfMaxHttpCollectionKeysExceeded()

We had a reporting services (2008) report that worked fine on UAT but not on live.  The report had parameters but when they were set and the View Report button pressed nothing much happened and the report would not run.  239 more words

Power Query and SSRS Metadata

If you have ever tried to parse XML using SSIS and/or SQL Server, and found it to be a little tedious, then you may want to try using ‘Power Query’ for your XML parsing. 492 more words

SQL Server

Sql Server Reporting Services - Does Date Cover Entire Day?


One of our users pleasantly gave me a list of things she will like to change in our Reports. The list includes whether we can assume entire day, when she presents us with a day. 326 more words


Integrating Other Data Mining Tools with SQL Server, Part 2.2: Minitab vs. SSDM and Reporting Services

By Steve Bolton

…………Professional statistical software like Minitab can fill some important gaps in SQL Server’s functionality, as I addressed in the last post of this occasional series of pseudo-reviews. 3,602 more words

SQL Server