SqlServerDBA318,  I am unsure of your environment/rdl but things I would check:

1) Are you performing index maintenance on the new indexes
2) What else is running at the...

If I understand your description correctly, you are trying to show a drill-through report.  Or are you attempting to do this matrix with 2 datasets?

If I understand correctly from your description, you need a column group.  The column group is actually the expression that you are describing.  This should allow for the click-through calculation...

Have you tried to group the dataset in SSRS?  You can group on multiple columns for the tablix and then create a header row for the group (where the header...

Thank you sir.  It is much more elegant than the solution I was working on.

Thanks for the question! The mass of code was to make sure that I would give anybody who attempts to answer the Conundrum the full code I am working with....

SQL Newbie - try this link from StackOverflow:  https://stackoverflow.com/questions/40361594/tsql-order-by-on-occasion-doesnt-order-correctly

Curious Question: Why use the PowerShell task over the CmdExec task?  I know in your article you are calling the PowerShell executable, hence the use of the CmdExec task.  I...

If the column is a data-type of datetime, I wouldn't suggest using LIKE expressions.  You can use something alone the lines of 
WHERE YEAR(ContractEnrollDate) = 2006 AND (MONTH(ContractEnrollDate)...

I will readily admit that I got this question wrong.  My issue is that the reference I read (which was posted after I was informed I was incorrect) was talking...

Thank you for your responses.  You have given me food for thought.