-
Distinct combination selection
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 SSRS custom sort order
If you have a column (or row) group called City with values of Adelaide, Brisbane or Cairns, you can sort A-Z, Z-A or perform a ... -
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 ...
