-
Distinct Combination Selection in SQL
I have a need to determine the distinct number of combinations of selections in a fantasy competition - where the competition is to guess the ... -
Create a Custom Sort Order in SSRS and Paginated Reports
There are times when alphabetical or numerical sorting just will not cut it. Whether you are designing dashboards for executive review or producing print-ready Paginated ... -
SSRS and Project Subfolders
If you're like me, you like to keep your reports well organized. This gets harder when you start to deal with hundreds of reports across ... -
Multiple labels on bar chart
I'm building a "dashboard" in SSRS that updates every minute to show the results of a particular horse race. One area on the page displays ... -
Find SSRS subscriptions of an email address
I recently had the need to remove an email address from all SSRS subscriptions as a certain person was no longer with the company. Rather than ... -
Find the datatypes of a SQL #temp table
I'm sure you've done it a million times like I have: selected a chunk of data into a #temp table for some quick and dirty ... -
Excel Lookup - Maintain Date Format
Consider the following spreadsheet in Excel: I wish to perform a lookup on these fields to build a dirty INSERT into SQL list, however when ... -
Sort In Original Order When Grouping
I am working on analysis against the Soccer World Cup in Brazil and have one small problem; for some reason a handful of event actions ... -
Get First Day & Last Day of Last Week
I have a requirement to generate data for reporting for the previous week, where the week starts on a Monday and ends on a Sunday.The requirement ... -
SSRS - Hide textbox if no data
Within SQL Server Reporting Services 2008, hiding a tablix is simple when there are no rows in the dataset. Simply add this expression to the ...
