Thank you Daniel, this is what I ultimately decided on doing. I am just trying to decide on how I want the tablixes to filter the data. Not sure if...

Thank you, the problem was the result of both! (the parameters not being passed correctly, as well as expressions in the subreport to return all when none were selected)

Thank you, I will look into WMI Data Reader Task functionality to see if this can aid with my goal. But more generally, I was seeing if I could understand,...

Correction- the folder is there. However, there are no data sources under the Data Sources folder.

Sorry in advance for my novice question, but how will a CASE WHEN ISMEMBER() THEN clause be useful if the user is tasked with writing his own query in the...

That was a clever solution you found. I've also experienced this issue before, as it is quite common. Sometimes I've found the solution to lie in setting the "ConsumeContainerWhiteSpace" property...

How are you entering the values for your child parameter? Are you getting values from a query? If so, I'd recommend using a clause to remove the Filter1 value from...

Try entering N2 in the format property of the textbox

What is the expression you're using?

Sorry and thanks.

Wanted to update this thread with my solution should anyone else come across this issue. The following is the code that was ultimately used, which also applies some conversion and...

How will upgrading to 2012 work around this limitation? From what I understand, the limitation is on the Excel side (max 256 columns per worksheet). Upon further investigation, I found...

Way too complicated imo. I would simply create a view that joins on a range table with degree values like "high," "medium," "low" and then use boolean expressions to set...

What about bypassing the 256 column limit? Is there anyway to bypass this? I have...

To address this issue, use a view and join on the appropriate accounts. You can sum in the dataset queries or through expressions in the cells.