Even though the default option is to sort a grouping by the same expression as the grouping and the displayed value, that is not necessarily what you want, and it...

Your expression should use the & symbol instead of the + symbol, which is a SQL concatenation symbol but not for SSRS expressions.

Of course you can point directly at your tables without the CTE. Just drop the top part and use the query at the bottom, with your table name in place...

I took your example data and put it into a CTE format so it can be queried. You will find that on this forum board people are more likely to...

Jeff,

I was mistaken because I looked too quickly over the code and didn't read it properly. My code was neither shorter nor simpler.

I am appropriately abashed.

Geoff

I think this is a slightly shorter solution.

LastName = reverse(left(reverse(FullName), charindex(' ', reverse(FullName)) - 1))

More information is definitely needed to give any advice. I think the first thing I would like to know is the expression you are trying to use to toggle the...

Probably the same item is being counted under more than one date of the matrix, but when you count items across all dates, it is being counted only once.

Without knowing...

My preferred approach would be to do the pivoting of the data in the query for the dataset, like this:

select

sales_person_id,

JanJun2012 = sum(case when month(sale_date) <= 6 and year(sale_date)...

In the design, make the text box only big enough to hold the <Exp> placeholder text. Text boxes have a "can grow" property turned on (true) by default, so if...

I cannot visualize your design clearly enough with the information I have to make a further recommendation. If you can attach a screenshot of the design layout, I might be...

Make sure the Report property of "ConsumeContainerWhiteSpace" is set to "True." Then use the Visibility property of each of the text boxes and define an expression that will return "true"...

I'm not sure what to suggest, but perhaps the RDL has some sort of glitch in it that is preventing the refresh of the included columns. I suggest deleting and...

It is not the version of Visual Studio that determines if certain functions are supported, but only the version of SQL Server and Reporting Services that is rendering the RDL...

On second thought, I guess you could get away without a tablix if your dataset contains only one row of information, or is filtered to just one, as it seems...